Thanks the solution was posted on this site. You have to format the field in
word by toggling between the fields and adding \#00.00. Why does excel
represent the number correctly and word does not until it's formatted?


"Brig_view" wrote:

I have an excel file used in a mail merge, the file has been formatted as
numbers to 2 decimal places eg. 10.01, 10.03. When I use this file in the
mail merge I get 10.03 represented as 10.0299999. How do I make word
represent the numbers I have in the excel file?