Word 2003 Mail Merge

[M.E. Jetsam]

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

 

[Graham Mayor]

What switch did you use?

It should be \# ",$0.00"

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[M.E. Jetsam]

Actually, what worked was:

\# "$,0.00"

What switch did you use?

It should be \# ",$0.00"

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Graham Mayor]

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>