0's as blanks in merge

[ksurodeochick]

We are trying to merge numbers onto a word document. We have a If. . . Then statement set up. If " " is greater than zero, then "do this". It does that, but when the value is not greater than zero, it puts a zero insead of leaving it blank.

When you merge address fields, when those are blank, they don't print those. Someone please help us, we are about to stress out!

 

[macropod]

Check out yesterday's post on 'Empty field returns "0"' in this forum.

Cheers

We are trying to merge numbers onto a word document. We have a If. . .

Then statement set up. If " " is greater than zero, then "do this". It
does that, but when the value is not greater than zero, it puts a zero
insead of leaving it blank.

When you merge address fields, when those are blank, they don't print

those. Someone please help us, we are about to stress out!

 

[Graham Mayor]

See http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>