Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
I'm using an Excel sheet to populate merge fields in a Word document.
Despite assorted attempts to put a picture switch on the field according to the help directions, Word insists on dropping trailing zero's after the decimal, e.g. $27.60 is displayed 27.6 The date in Excel is formatted #,###.00 but Word Help says that's irrelevant. ALT F9 displays {MERGEFIELD "F26"} To no avail, I've tried: {MERGEFIELD "F26" #\ #,###.00}; {MERGEFIELD "F26" \# $#,###.00} just like the help instructions; and more creatively, {MERGEFIELD "F26" }#\ #,###.00. What am I doing wrong? |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Word & WordPerfect | Microsoft Word Help | |||
Word should allow to 'divide' page by 3 or 4, not just 2 | Page Layout | |||
CPU Usage When working with a Template I Created | Microsoft Word Help | |||
Envelope Address | New Users |