why is the zero falling off a zip code in excel?

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

Guest

I am doing a spreadsheet in excel and in the zip code field the zero is
falling off the front. it is 08015 and it keeps changing to 8015. can
anyone tell me why?
 
Pre-format the cell(s) as TEXT or type a leading apostrophe before typing the
zip with the leading zero........

Vaya con Dios,
Chcuk, CABGx3
 
Numbers are just numbers to excel. And 1 = 00000000001, so it doesn't care and
won't show them--unless you do something special.

#1. PRE-Format the cell as text (format|cells|number tab|Text)
#2. Start your data entry with an apostrophe ('08015)
#3. Give the cell a custom format
(Format|Cells|number tab|custom category)
00000
or if you could have 9 digit zips:
[>99999]00000-0000;00000
 
You must log in or register to reply here.

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

How can I get a leading zero (ZIP code) to show in a LEFT() calc? 2
Editing a cell in Excel spreadsheet 2
NumberFormat for small non-zero numbers? 2
Function to Count Zip Code Digits With Leading Zero 2
Displaying zeros in cells 2
Format>Cells>Special>Zip Code 5
Excel time leading 1st ZERO 3
How do I add a zero in front of a text formatt number? 3

Back
Top