Numbers change in merge from Excel to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amanda - 01 Nov 2003 02:51 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 01 Nov 2003 03:33 GMT

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

> Hi,
> I've got a new template and data source ready to go for a
[quoted text clipped - 9 lines]
> currently using Windows XP. If anyone knows an answer,
> I'd appreciate it.

Reply to this Message