[Kim]

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

[macropod]

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
--
macropod
[MVP - Microsoft Word]
-------------------------

"Kim" wrote in message oups.com...
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

[Kim]

On Oct 2, 5:00 pm, "macropod" wrote:
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
--
macropod
[MVP - Microsoft Word]
-------------------------



"Kim" wrote in ooglegroups.com...
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- Hide quoted text -

- Show quoted text -

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