| 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 | |||
Linear Mode
