View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
sueg sueg is offline
external usenet poster
 
Posts: 26
Default Mailmerged Dollar Amount Problem

I had trouble finding what I need. How would you do it? I have a 2003 Excel
field formatted in Excel as currency/automatic comma/2 decimal places. I
need to merge this into a 2003 Word letter.
Thanks for your help!
--
sg


"Graham Mayor" wrote:

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.