Mail merge amount appeared multiple decimals

[cyin]

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

 

[Doug Robbins - Word MVP]

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


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