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
Labels:
Excel,
Productivity
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment