Format Zip Code

[lipipe]

Good Evening,

I am trying to make the zip codes in my file uniform. Currently I have some zip codes that are 03301-2862, some that are 06416, and some that are 03301-0000. I want to make all of the 5-4. When I try to do it in excel with number format it takes 06416 and makes it 0000-6416. How can I leave the zip codes that are 5-4 along and fix the single 5 digit zip codes without messing up the code itself.

Thanks in advance.

Jack

 

[CWatts]

You could use conditional formatting.

For example, format A1 as 00000-0000 number format. You can then use conditional formatting less less than 99999 and then set the number format to 00000.

The only way that would fail is if you had 00001-1111 as that would read 5 digits, but since the lowest zip code is 00501, then that should do the trick.