How do I handle zip codes beginning in zero?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a huge spreadsheet of mailing addresses and some of the zip codes
begin with zero. The zero gets deleted and I end up with only 4 numbers
instead of 5. How do I get it to recognize the number zero without messing
up the rest of the numbers in the zip code?
 
The simplest way is to change the format of that column to text and then the
leading zeros will survive.
 
Dean gave you one way. Another way is to format the cell to always have 5
numeric characters.

Click Format/Cells from the menu toolbar and choose "Custom". Then put five
zeroes in the "type" field and press OK.

That ensures all leading zeroes are maintained, and still treats the number
as a number.

Allison
 
Back
Top