Hi Graham,
Looking at your switch, I do believe that I didn't use the first comma. I
am fairly new to this. I did although update the field. I am sure if I would
have input the comma I would have had better results

Mike

"Graham Mayor" wrote:

Did you update the field after adding the switch?

{Mergefield Amount \# ",$0.00;(,$0.00);" }
should work. How did you enter it?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Michael wrote:
Thanks for your input Doug. I tried earlier what you had suggested,
but somehow I could not get it to work. What I eventually used (and
works well) was this:
{if {mergefield fieldname} 0 "{mergefield fieldname}" }

Thanks again!
Mike

"Doug Robbins" wrote:

What formatting switch are you using?

To show positive and negative amounts but nothing for zero amounts,
use:

\# "$,0.00;-$,0.00;"

or

\# "$,0.00;($,0.00);"

To just show the positive amounts, use:

\# "$,0.00;;"



--
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
"Michael" wrote in message
...
Hello,
Could someone help me with this? I am using an excel database to
populate a
form in Word. It is calculating dollar values and bringing them
into Word.
I can't seem to suppress the zero's in fields that should be blank
because there is no value. I have been to G Mayor's site and tried
what is there but
it does not seem to work. Any suggestion's???

Thanks in advance,
Mike