Thread: How do I format a merged field in Word to display an amount?
View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mrs G
 
Posts: n/a
Default How do I format a merged field in Word to display an amount?
I have the main document set up to display an amount, but when I merge the
excel spreadsheet, the amount displays $ 36.350000000000001. I have only
enter 36.35 in the cell on the excel spreadsheet. Can someone tell me how to
fix this to read
$ 36.35?

Also, when I manually delete the extra digits, they still print on my letter.
Reply With QuoteReply With Quote