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?