Peter - I just checked my code and I guess with all my queries out there last
Friday, I must have found the right syntax because I have the # sign in there
now.
Thanks so much for the clarification. I was so happy to see that it worked
before I went home on Friday. Love it when things work.
Again, thanks everybody for all your continued support. I don't know what
I'd do without my MS Tech group.
Susan May
"Peter Jamieson" wrote:
As posted, there is a "#" missing from your field code - you have
{MERGEFIELD "Sale" \"$,0.00; ($,0.00)"}
and you need
{MERGEFIELD "Sale" \#"$,0.00; ($,0.00)"}
Peter Jamieson
http://tips.pjmsn.me.uk
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.