View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail merge amount appeared multiple decimals

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

"cyin" wrote in message
...
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