Mail merge amount appeared multiple decimals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cyin - 21 May 2008 03:49 GMT

I am doing a simple mailmerge from data in excel, when i merge a field
contains amount with 2 decimal point, it appear in word with 13 decimals.
Example: 2,848.99 in excel data field
after merge to word, it appeared as 2849.9899999999998
Can anyone teach me how to make it to appear same as excel format?
Thanks in advance
Cyin

Reply to this Message

Doug Robbins - Word MVP - 21 May 2008 04:38 GMT

Press Alt+F9 to toggle on the display of the field codes and insert the
following formatting switch inside the closing }

\# ",0.00"

For more information, see "Formatting Word fields with switches" on fellow
MVP Graham Mayor's website at:

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am doing a simple mailmerge from data in excel, when i merge a field
> contains amount with 2 decimal point, it appear in word with 13 decimals.
[quoted text clipped - 3 lines]
> Thanks in advance
> Cyin

Reply to this Message