Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I format a merged field in Word to display an amount?
See this link: http://www.gmayor.com/formatting_word_fields.htm
"Mrs G" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
Word should allow to 'divide' page by 3 or 4, not just 2 | Page Layout | |||
Converting Word Perfect forms to Word forms | Microsoft Word Help | |||
Underscore (_) will not always display in RTF files (Word 2002). | Microsoft Word Help |