Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can't get switch to work on numerical data merged to Word from
You would need to update the fields to get the new format to be displayed.
-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jeannie McQuaid" wrote in message ... Actually the website didn't help me discover how to fix my problem...but it is fixed. I was putting in the switches and hitting ALT F9 to hide the coding thinking that I should immediately see the results of the switch. But I discovered when I opened the document to try the instructions from the website, my switches seemed to working. I'm assuming that in order for the switch to take effect, I had to close the document and reopen. (none of the help information included that little point!) Thank you for taking the time to look at my problem. Jeannie "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jeannie McQuaid" wrote in message ... 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
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 |