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 |
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 |