I am doing a mail merge in Microsoft Word and pulling the data from an Excel spreadsheet. The text is being inserted perfectly, but when I go to insert a number value, the number goes out to fifteen decimals places when it should only be out to two decimal places.
I have tried using the ROUND(cell,2)
formula as well as Special Paste->Value
, but both times Word still outputted numbers fifteen decimal places out. How can I control the formatting of these numbers in mail merge so that they display in a fixed two decimal format (i.e. $8.00, $5.20, $7.49)?