Wednesday, October 20, 2010

MS Word Mail Merge: Not making cents?


This issue comes up when writing a mail merge letter where you are including dollar amounts from a calculated formula column — such as... “Money Turned In” and “Money Still Due/Owed.” 


In some cases you can just change the cell format to Text, but not if that column/cell has a formula in it and needs 2 decimals to show cents! 

Below is a link to instructions that worked just wonderfully the other morning... BUT (one change to the instructions...) you will need to use “0.00x” for 2 places after the decimal (such as for cents), and “0.0x” only goes 1 place after decimal.

http://wordprocessing.about.com/od/usingmailmerge/qt/NPFSwitch.htm



No comments:

Post a Comment