Change
{MERGEFIELD "Sale" \"$,0.00; ($,0.00)"}
to
{MERGEFIELD "Sale" \# "$,0.00; ($,0.00)"}
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Susan May wrote:
Doug - I just tried to do this and it didn't work. My field codes
look like this
{MERGEFIELD "Sale" \"$,0.00; ($,0.00)"} and it doesn't change the
format of the number that I'm importing from Excel. What am I doing
wrong?
"Doug Robbins - Word MVP" wrote:
Press Alt+F9 to reveal the field codes and insert
\# "$,0.00;($,0.00)"
before the closing }
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Andrea" wrote in message
...
I would like to format my numbers in a mail merge to be shown as
Currency so
with $ and 2 decimals. I know I can do this with a field code but
can't get
it to work.