Suppressing zeros in a mail merge document
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
|