Numbers change in merge from Excel to Word

[Amanda]

Hi,
I've got a new template and data source ready to go for a
merge and I've ironed out all the problems except this
one:
When my data goes from my Excel data source to my Word
document, the zeros on all my numeric currency values
disappear (ex. $4.50 becomes $4.5). As this is for
billing purposes, it will not do. I've tried every
option in Excel and know that the problem must lie in
either the translation of data from Excel to Word, or in
some setting in Word itself that I can't find. I'm
currently using Windows XP. If anyone knows an answer,
I'd appreciate it.

 

[Doug Robbins - Word MVP]

Hi Amanda,

In the mailmerge main document, use Alt+F9 to toggle on the field codes and
inside the closing } of the currency mergefield, add the following
formatting switch:

\# ",$#.00"

Use Alt+F9 again to toggle off the field codes and then execute the merge.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP