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?