[Doug Robbins - Word MVP]

Add the following formatting switch to the mergefield

\# ",#.00;(,#.00);"

That will give you numbers to two decimal places with a thousands separator,
with negative numbers in parentheses and a blank for a zero.

Delete the .00 if you don't want the decimals places.

--
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

"Lyn" wrote in message
...
I am attempting to merge data from Excel into a word document (table). I
have the zeros suppressed in Excel. However, after the merge, the word
document shows zeros when I would prefer blanks. How do I suppress the
zeros? If I have to use an IF statement in the merge document, what is
its
syntax?

PS This was not a problem in Word 2003.
--
Lyn