3 possible zips

[tjtjjtjt]

I've read through a couple of the discussions about zip codes, and I found myself asking a question
What if I have one of 3 possible zip code formats
This is what I mean
I may have to format zip coeds for the opening "0"--the discussions here allow me to do that
I may need to format numbers for the zip+4 format--the discussions here allow me to do that

What I haven't been able to do yet is format the field so that I can have the opening zero when needed, include the +4 when it has been provided, and leave off the +4 when it has not been provided
I haven't tried putting the +4 in a separate field in the Excel List, and, if anyone can help format the field so I don't have to, I would greatly appreciate it

tj

 

[Greg Maxey]

tjtjjtjt,

See the US Zip Code tip at:
http://www.gmayor.com/formatting_word_fields.htm

 

[tjtjjtjt]

Thanks, but I got it. And I was using the URL--I think you or someone else put it up in a previous post. I'm not used to working with Word fields, so I bungled my logic a bit. What I was doing wrong was thinking of these as 3 possibilities. Then, I realized I could just set a condition to format anything smaller than 1000000 and a condition to format anything bigger. One nice, simple If field. Thanks.

tj