Formatting Nubers in Word Table after Mail Merge Ryan 10/30/2008 1:24:00 PM I have created a mail merge that draws information from a spreadsheet (Excel) and places a series of dollar amounts into a table in the Word document. The problem is that the numbers on the Word document don't follow the dollar format as set up in the Excel spreadsheet so I get values like 113247.1 instead of $113,247.10. Is there a way to change the format of these cells in the Word table so that they are in the Currency or Accounting format?

Re: Formatting Nubers in Word Table after Mail Merge "Rich/rerat" <rrr_news[ at ]isp.com> 10/30/2008 5:09:22 PM Ryan, Graham Mayor's excellent site for information about Formatting Word Fields w/Switches: http://www.gmayor.com/formatting_word_fields.htm For your problem you would you would form your mergefield like this: {mergefield "amount" \# "$ ,0.00;($ ,0.00)"} -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule> <<Previous Text Snipped to Save Bandwidth When Appropriate>> "Ryan" <Ryan[ at ]discussions.microsoft.com> wrote in message news:C62E744E-F5F9-464B-80B5-8E2910D8A949[ at ]microsoft.com... I have created a mail merge that draws information from a spreadsheet (Excel) and places a series of dollar amounts into a table in the Word document. The problem is that the numbers on the Word document don't follow the dollar format as set up in the Excel spreadsheet so I get values like 113247.1 instead of $113,247.10. Is there a way to change the format of these cells in the Word table so that they are in the Currency or Accounting format?