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