Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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

 
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 09:52 AM.

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

About Us

"It's about Microsoft Word"