Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Word have Keyboard Merges like Word Perfect does? | Mailmerge | |||
Word2000 letterhead merge | Mailmerge | |||
1st word in heading flush left second word flush right | New Users | |||
letters - ask/fillin | New Users | |||
how to convert wordperfect 5.0 floppy files to word | Microsoft Word Help |