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?