how do I enter a zipcode starting with a 0

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

Guest

i am typing a name list. Some of the zipcodes start with a 0 (east coast).
Excel doesn't show the 0 and shows only 4 digits. How do I get it to show the
0
 
If these are all 5 digits then you could format via Format>Cells...Custom as
00000 or you could pre-format the cells as text (Same route and select text
from the formatting list) or prefix with a single apostrophe '. It will hold
the 0 but will not display itself

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Bea VanKampen said:
i am typing a name list. Some of the zipcodes start with a 0 (east coast).
Excel doesn't show the 0 and shows only 4 digits. How do I get it to show the
0
Click to expand...

Format the cells with Format>Cells>Special>Zip Code
 

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

Adding a 0 to a four digit number 5
Create Database Type Lookup In Excel 4
trying to insert a 0 in front of zipcode 2
2 Files with Different Fields 6
Not printing 0 in zipcodes from excel spreadsheet. 1
How do I zip sort mailing list when I have 5 digit AND 9 digit zip 1
How do I get Excel not to erase a leading Zipcode zero (eg 0xxxx) 1
Tallying more than one list of data into one main control list 1

Back
Top