Mail merge field formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Judy123 - 25 Apr 2006 22:22 GMT

The column I created in excel was formatted as currency ($8.70); after I
merge my information to the word main document, when I preview it shows as
8.7, what am I doing wrong?

Reply to this Message

Peter Jamieson - 26 Apr 2006 01:12 GMT

You aren't doing anything wrong, but unfortunately Word loses the
formatting. You can either
a. check Word Tools|Options|general|Confirm conversions at open, then
reconnect to the Excel data source and choose the DDE option when offered,
or
b. put "numeric format switches" in all the appropriate fields in Word,
e.g. if you press Alt-F9 in Word and see

{ MERGEFIELD mynumber \*Mergeformat }

change it to

{ MERGEFIELD mynumber \#,$0.00 \*Mergeformat }

Peter jamieson

> The column I created in excel was formatted as currency ($8.70); after I
> merge my information to the word main document, when I preview it shows as
> 8.7, what am I doing wrong?

Reply to this Message

Judy123 - 26 Apr 2006 14:43 GMT

I can not thank you enough for your help. I used option b. and it worked like
a charm! Not only were you right on target, your instructions were very
detailed and easy to follow. Thank you again; you saved me much "fustration".

> You aren't doing anything wrong, but unfortunately Word loses the
> formatting. You can either
[quoted text clipped - 14 lines]
> > merge my information to the word main document, when I preview it shows as
> > 8.7, what am I doing wrong?

Reply to this Message

Graham Mayor - 26 Apr 2006 05:55 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> The column I created in excel was formatted as currency ($8.70);
> after I merge my information to the word main document, when I
> preview it shows as
> 8.7, what am I doing wrong?

Reply to this Message