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

[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

 

[Harlan Grove]

lose the leading zero. For example, 07109 becomes 710.

....

If your zip codes are numbers, you need to use

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

 

[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

this handles the whole list in one action.

 

[Ron Rosenfeld]

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

=MOD(zipcode, 1000)


--ron