I need MS Word Mail Merge Help!
I have a templated letter in MS Word and information stored in an Excel file.
The field I want merged is a dollar amount. For example, it displays on Excel like $2,104.10 but when it merges it displays $2104.1. How do I get it to add the comma and the 0? Not all amounts end in zero, some are $22,104.11 but display as 22104.11.
This is how the original looks.
"...company totaling $«Amount»."
I posted this question on another board and they suggested I use "{MERGEFIELD number \# $####,0.0}"
But I don't know how to format it correctly in the document to make it workto make the amount format correctly?? into there someway or another?
|