Word 2003 Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M.E. Jetsam - 21 Sep 2005 20:51 GMT

Having trouble formatting merged data field. I edited the field code, chose
the picture switch that should give me $##,###.##, but after I merge, the
numbers are not what should be in that field, i.e. what should be $300.00 is
$1,054.00??????

Reply to this Message

Graham Mayor - 22 Sep 2005 06:30 GMT

What switch did you use?

It should be \# ",$0.00"

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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Having trouble formatting merged data field. I edited the field
> code, chose the picture switch that should give me $##,###.##, but
> after I merge, the numbers are not what should be in that field, i.e.
> what should be $300.00 is $1,054.00??????

Reply to this Message

M.E. Jetsam - 22 Sep 2005 19:52 GMT

Actually, what worked was:

\# "$,0.00"

> What switch did you use?
>
[quoted text clipped - 6 lines]
> > after I merge, the numbers are not what should be in that field, i.e.
> > what should be $300.00 is $1,054.00??????

Reply to this Message

Graham Mayor - 23 Sep 2005 07:18 GMT

My apologies - finger trouble on the keyboard. :(
You would have picked up the correct switch from my web page.

Signature

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

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

> Actually, what worked was:
>
[quoted text clipped - 18 lines]
>>> after I merge, the numbers are not what should be in that field,
>>> i.e. what should be $300.00 is $1,054.00??????

Reply to this Message