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?