Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zip Code field returns 00000 when nothing in field in from xls
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zip Code field returns 00000 when nothing in field in from xls
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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zip Code field returns 00000 when nothing in field in from xls
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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge field link to database returns value w/255-character limit. | Mailmerge | |||
Field code being displayed and not the field | Microsoft Word Help | |||
Word 2003 Field code within a field code | Mailmerge | |||
Which field code? | Microsoft Word Help | |||
MS Word 2002 Template - How to prevent Hard returns in text field. | Page Layout |