Add the following format picture switch to the field

\# "0;-0;"

--
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
"Richard" wrote in message
...
How can I surpress the printing of zeros in a field that is blank in the
data
source (in this cace, Excel)