0's as blanks in merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ksurodeochick - 22 Jul 2004 20:50 GMT

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!

Reply to this Message

macropod - 23 Jul 2004 00:58 GMT

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!

Reply to this Message

Graham Mayor - 23 Jul 2004 06:12 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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
[quoted text clipped - 3 lines]
> When you merge address fields, when those are blank, they don't print
> those. Someone please help us, we are about to stress out!

Reply to this Message