Word adds extra decimal places to number fields when merging why?

[Mark]

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?

 

[Graham Mayor]

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Mark]

Thank you very much, it is now working lovely!

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>