Mail Merge Currency Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 16 Dec 2003 21:44 GMT

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

Reply to this Message

Peter Jamieson - 17 Dec 2003 00:19 GMT

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" }

--
Peter Jamieson - Word MVP

> 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

Reply to this Message