How do I keep zeros in front of other numbers (like a zip code)?

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

Guest

I'm doing a customer tally sheet which includes zip codes. Excel keeps
erasing the the first zero - 01085 for example will show up as 1085. Is
there any way to keep that from happening?
 
If you are entering them use the format text first, or type ' and then the
number.
I have a format under special that is specially for "zipcodes" but seeing as
I am in Norway they are really postnummer. Maybe you have the same???
 

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 do I keep a zero in my first number of zip code 2
Saving a CSV file from Excel with 0 in front of Zip code 10
How do I remove the apostrophe(') in front of zeros 3
changing zip code to number 3
formatting zip codes 1
I want to display numbers with zeros in front of them, eg 005 8
How do I get excel to start a numberwith a zero as in a zip code? 3
How do I get leading zeros in zip codes in a mail merge 1

Back
Top