Convert a 5 digit zip code to a 3 digit zip code

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

I have a database already containing names and addresses.
I would like to convert the 5 digit zip code into a 3
digit zip code so it can be used for territory
assignment. The problem I seem to have is that I always
lose the leading zero. For example, 07109 becomes 710.
Any help would be appreciated. I have tried using a Zip
code and custom format and then using the "text to
columns" to separate the zip with no luck.

Thanks,
Carl
 
-----Original Message-----

....

If your zip codes are numbers, you need to use

=LEFT(TEXT(ZipCode,"00000"),3)


.
Thanks for the help! I had found another solution but
Click to expand...
this handles the whole list in one action.
 
I have a database already containing names and addresses.
I would like to convert the 5 digit zip code into a 3
digit zip code so it can be used for territory
assignment. The problem I seem to have is that I always
lose the leading zero. For example, 07109 becomes 710.
Any help would be appreciated. I have tried using a Zip
code and custom format and then using the "text to
columns" to separate the zip with no luck.

Thanks,
Carl
Click to expand...


=MOD(zipcode, 1000)


--ron
 
Back
Top