Forum Discussion
zip code
Hello I am in Microsoft excel. I copied a Zip column into excel. The zip code is suppose to say "08854". For some reason it says "8854". an some please explain to me why it is not showing the "0". I ...
It suppose to. Because excel trying to identify your zip code as a numerical data. Thus, any 0 in prefix would be meaningless, so excel clear it automatically.
Solution is very simple. Just change your cell format to Text. This way excel would identify your zip code as a string data.