Question on Formatting numbers

rukhl

New Member
Joined
Feb 12, 2005
Messages
3
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
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

rukhl

New Member
Joined
Feb 12, 2005
Messages
3
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

Board Regular
Joined
Dec 17, 2004
Messages
171
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,451
Messages
5,572,193
Members
412,447
Latest member
immy
Top