Forum Discussion
Samon1900
Oct 04, 2022Copper Contributor
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 ...
Ezio-de-Pazzi
Oct 04, 2022Brass Contributor
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.