3 possible zips

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tjtjjtjt - 31 Jan 2004 17:26 GMT

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

Reply to this Message

Greg Maxey - 31 Jan 2004 17:43 GMT

tjtjjtjt,

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

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org

> I've read through a couple of the discussions about zip codes, and I
> found myself asking a question:
[quoted text clipped - 13 lines]
>
> tj

Reply to this Message

tjtjjtjt - 31 Jan 2004 18:01 GMT

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

Reply to this Message

Rate this thread: