[Scott]

Hello,

I have a mail merge where the source data is in Excel. I am bringing in a
dollar amount of $19,890.22 that's rounded to two decimal places within
Excel. When I bring this amount into the Word mail merge, I get
19890.222222222222.

How do I get the numerical format in Excel to show up in my Word mail merge?

Thanks for your help.

Scott

[Graham Mayor]

Toggle the field display (ALT+F9) from fieldname
to
{Mergefield Fieldname}
Add a formatting switch eg {Mergefield Fieldname \# "$,0.00}
then F9 to update.
Alt+F9 to toggle the display again.
See http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

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



Scott wrote:
Hello,

I have a mail merge where the source data is in Excel. I am bringing
in a dollar amount of $19,890.22 that's rounded to two decimal places
within Excel. When I bring this amount into the Word mail merge, I get
19890.222222222222.

How do I get the numerical format in Excel to show up in my Word mail
merge?

Thanks for your help.

Scott