Reply
 
Thread Tools Display Modes
  #1   Report Post  
Mark
 
Posts: n/a
Default Word adds extra decimal places to number fields when merging why?

I am merging values from an Excel spreadsheet into a Word document. Some of
the fields' values are money (numbers to 2 decimal places), but when they
appear in the merged document they appear with 14 decimal places.
For example:
172.68 in the spreadsheet appears as 172.67999999999998 in the letter!
I cannot understand why!
I thought it might be a rounding error, because the excel field was an
addition of a few other fields, so I changed the spreadsheet. Doing the
addition manually and typing the column of numbers with just two decimal
places, but this did not change the way that Word treated them when I did the
mail merge.
Does anyone have any ideas how I can stop this from happening?
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

You need a formatting switch -
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Mark wrote:
I am merging values from an Excel spreadsheet into a Word document.
Some of the fields' values are money (numbers to 2 decimal places),
but when they appear in the merged document they appear with 14
decimal places.
For example:
172.68 in the spreadsheet appears as 172.67999999999998 in the letter!
I cannot understand why!
I thought it might be a rounding error, because the excel field was an
addition of a few other fields, so I changed the spreadsheet. Doing
the addition manually and typing the column of numbers with just two
decimal places, but this did not change the way that Word treated
them when I did the mail merge.
Does anyone have any ideas how I can stop this from happening?



  #3   Report Post  
Mark
 
Posts: n/a
Default

Thank you very much, it is now working lovely!

"Graham Mayor" wrote:

You need a formatting switch -
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Mark wrote:
I am merging values from an Excel spreadsheet into a Word document.
Some of the fields' values are money (numbers to 2 decimal places),
but when they appear in the merged document they appear with 14
decimal places.
For example:
172.68 in the spreadsheet appears as 172.67999999999998 in the letter!
I cannot understand why!
I thought it might be a rounding error, because the excel field was an
addition of a few other fields, so I changed the spreadsheet. Doing
the addition manually and typing the column of numbers with just two
decimal places, but this did not change the way that Word treated
them when I did the mail merge.
Does anyone have any ideas how I can stop this from happening?




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
Does Word have Keyboard Merges like Word Perfect does? Donnas Mailmerge 1 June 28th 05 09:30 PM
Word2000 letterhead merge BAW Mailmerge 3 June 25th 05 01:17 PM
1st word in heading flush left second word flush right Elin New Users 9 April 4th 05 08:44 PM
letters - ask/fillin Caroline H New Users 2 February 25th 05 09:19 PM
how to convert wordperfect 5.0 floppy files to word pcoelho Microsoft Word Help 2 February 17th 05 07:55 PM


All times are GMT +1. The time now is 02:46 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"