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 even ent as far as trying to manual put the "0", but it keeps dissappearing everything time I click out of the box.
4 Replies
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.
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.
- 30605
