View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mailmerged Dollar Amount Problem

You need a formatting switch on the Word field - see
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Laurie wrote:
In Office 2003 using Excel spread sheet with dollar amounts as a
merge field in Word the dollar amount shows more then 2 decimal
places in the Word document. It is formated in the Excel document to
2 decimal places and is showing the correct amount in the formula
bar. How do I get Word to keep the formating or how do I format the
merge field to show only 2 decimal places? Thank you for your help.