How do I get excel to start a numberwith a zero as in a zip code?

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

Guest

When I type a zip code that starts with a zero into my xls database the zero
doesn't take.
 
Thanks Mike BUT if I format as text then the number may not be recognized as
a number and therefore will not produce the postal codes, ditto if i procede
with an apostrophe. I did find a way though that works fine - highlight the
column in which the zip goes and then under FORMAT - CELLS - SPECIAL - ZIP
CODE TYPE ok.
 
That will work if all you need if ZIP + 4

Zip Codes or parts of Zip codes are not used as numbers so preceding with an
apostrophe or pre-formatting to text has no deleterious effect.


Gord Dibben MS Excel MVP
 
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

ZIP codes 1
How to merge Excel address columns when some zips begin with zeros 4
Editing a cell in Excel spreadsheet 2
How to stop Excel from automatically truncating leading zeros 2
Entering zeros in Excel 7
Saving a CSV file from Excel with 0 in front of Zip code 10
mailing list zip code starting with a 0 does not show 0 1
formating zip codes with leading zero to print zero 1

Back
Top