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 ...
HansVogelaar
Oct 04, 2022MVP
Alternatively, prefix the value with an apostrophe, for example '08854. This forces Excel to treat the value as text. The apostrophe will show in the formula bar, but not in the cell itself.