Zip Code field returns 00000 when nothing in field in from xls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kim - 02 Oct 2007 22:36 GMT

I am using Grant's formula for 5 and 9 digit zip codes:

{If{MERGEFIELD ZIP} > 99999 "{MERGEFIELD ZIP \# "00000'-'0000"}"
"{MERGEFIELD ZIP \# "00000"}}

And it works like a charm, except when the cell is empty in Excel. I
get "00000" instead of a blank field. How do I suppress the zeros when
there is nothing in the field?

Thanks!
Kim

Reply to this Message

macropod - 02 Oct 2007 23:00 GMT

Hi Kim,

Try adding two ';;' characters to the end of the 2nd mergefield field, thus:
{If{MERGEFIELD ZIP} > 99999 "{MERGEFIELD ZIP \# "00000'-'0000"}"
"{MERGEFIELD ZIP \# "00000;;"}}

Those extra characters control the formatting for negative and 0 values, respectively. Having nothing after each of them suppresses
the negative and 0 value display.

Cheers

Signature

macropod
[MVP - Microsoft Word]
-------------------------

>I am using Grant's formula for 5 and 9 digit zip codes:
>
[quoted text clipped - 7 lines]
> Thanks!
> Kim

Reply to this Message

Kim - 03 Oct 2007 14:30 GMT

> Hi Kim,
>
[quoted text clipped - 24 lines]
>
> - Show quoted text -

Worked like a charm! I can't thank you enough!

Reply to this Message

Rate this thread: