Mail Merge Currency Formatting

[Guest]

Trying to do letters with currency in them but word won't
display the comma I am getting $5000 instead of $5,000,
excel formatting is correct. Can anyone help

 

[Peter Jamieson]

Use Alt-F9 in Word to display the fields and add a numeric format "switch",
e.g. instead of

{ MERGEFIELD myamount }

use

{ MERGEFIELD myamount \#"$,0.00" }