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)?