Formatting Nubers in Word Table after Mail Merge

[Ryan]

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?

 

[Rich/rerat]

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>>


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?