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