Question on Formatting numbers

[rukhl]

Hi

I'm trying to in put zip codes that start with a 0, but whenever I do the 0 disappears. Is there anyway to change the format so the 0 is included?
thanks,
Rachel

 

[joelnichols]

Format the cell as text.

 

[deviation]

format cells > special > zip codes (or zipcoses + 4)

 

[rukhl]

green triangle in corner

Thanks, both work. When I went back and added the zeros a small green triangle appeared in the corner. Is there a way to get rid of that?

 

[deviation]

i would recommend using the format as Zip Code.. the green triangle is telling you a number stored as text..

you can click on the green triangle and tell it to ignore error..

however if you ever want to perform a lookup function then it will not work with numbers stored as text