Can't get switch to work on numerical data merged to Word from XL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeannie McQuaid - 20 Jul 2006 18:46 GMT

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 to this Message

Doug Robbins - Word MVP - 20 Jul 2006 19:27 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

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

> 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
[quoted text clipped - 10 lines]
>
> What am I doing wrong?

Reply to this Message

Jeannie McQuaid - 20 Jul 2006 20:34 GMT

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

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 15 lines]
> >
> > What am I doing wrong?

Reply to this Message

Doug Robbins - Word MVP - 20 Jul 2006 21:16 GMT

You would need to update the fields to get the new format to be displayed.

Signature

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

> Actually the website didn't help me discover how to fix my problem...but
> it
[quoted text clipped - 32 lines]
>> >
>> > What am I doing wrong?

Reply to this Message

Rate this thread: