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???
 
Back
Top