zip special format issue's

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I am dealing with zip codes both 5 digit and 9 digit xxxxx-
xxxx.

I am having trouble becuase using special zip code format
in excel which is great when you just want to look at it.

The thing is I want ot copy 5 digit and make a field with
just the 1st 3 digits for region analysis.

Also I want to be able to make the 5 digit field into text
is this a bad idea.

What does everone else do to deal with this

I tried changing to text and lost all my lading zero's and
it's a mess.
 
I would suggest leaving the zip code format intact.

If the zip code is in A1 then in B1 enter =left(a1,5) will
give you the first five of the zip, format the column as
you wish. In B2 enter =Left(a1,3) will give you the first
three.

Charlie O'Neill
 
what is th ebest format for zips ( 5 & or 9) if I wan to
do vlookups and pivot tables , etc. And I guessI need ot
know how to convert from zip special to what ever
suggested.

I did oull a few thiongs of of google groups that may do
itbut would take a suggest.
 
I would still use the Left function to parse the data into
5 digits and 3 digits, then you can do a look up on either
the 5 or 3 digit columns.

Charlie O'Neill
 
thanks for your time
-----Original Message-----
I would still use the Left function to parse the data into
5 digits and 3 digits, then you can do a look up on either
the 5 or 3 digit columns.

Charlie O'Neill
.
Click to expand...
 
see below
-----Original Message-----
I would suggest leaving the zip code format intact.

If the zip code is in A1 then in B1 enter =left(a1,5) will
give you the first five of the zip, format the column as
you wish. In B2 enter =Left(a1,3) will give you the first
three.

Charlie O'Neill
.
Click to expand...
 
Back
Top