How do I handle zip codes beginning in zero?

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?
 
G

Guest

The simplest way is to change the format of that column to text and then the
leading zeros will survive.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to Count Zip Code Digits With Leading Zero 2
keeping initial zeros 1
How do I add a zero in front of a text formatt number? 3
Zip Codes Dropping Leading Zero 3
Sorting by 5 digit & 5 digit plus 4 zip codes 2
ZIP CODES 2
How do I input zeroes in a zip code for a mail merge? 1
zero "0" dropping from the beginning of my serial numbers 3

Top