Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
cyin cyin is offline
external usenet poster
 
Posts: 1
Default Mail merge amount appeared multiple decimals

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

  #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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a mail merged numbers print decimals to 2 places? Brig_view Mailmerge 6 September 25th 09 07:21 PM
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? gmax2006 Microsoft Word Help 1 March 28th 07 06:28 PM
mail merge keeps putting in decimals that are not on excel sheet eazy01 Mailmerge 1 August 24th 06 06:17 PM
Amount decimals control Marwan Mailmerge 1 July 2nd 06 03:28 PM
How do I keep mail merged numbers to two decimals Jim Mailmerge 1 September 3rd 05 06:46 AM


All times are GMT +1. The time now is 08:57 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"