View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rich/rerat Rich/rerat is offline
external usenet poster
 
Posts: 93
Default In Word '07, how do I format dollars merged in from Excel?

You can use a switch such as:
\# "$0.00" after the mergefield.

More detail info can be found at Graham Mayor's site:
http://www.gmayor.com/formatting_word_fields.htm

--
Have A Good Day
Rich/rerat

Add MS to your News Reader: news://msnews.microsoft.com
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate

"Partnering" wrote in message
...
I have a new version of 2007.
I merge into Word from Excel, but my dollars do not STAY formated, and I
cannot figure out how to hard-code the dollar formatting in Word.