0 preceding numbers

[smcadman]

I have a column that requires 6-digit number in the cells. The numbers begin with 0, such as 050801, 050802, 050803, etc. If the cells are formatted as text, they show as required, but if the cell is formatted as text, I lose the 0, and the cells now show as 50801, 50802, 50803, etc.
How can I have the 0 precede the other 5 numbers?

Flores

 

[IRstuff]

Create a custom format with leading zeros "000000"

TTFN

 

[smcadman]

That did it, thanks! I had tried 0#####, among other things, but I didn't try ALL zeroes.

Flores

 

[quark]

Simply, put the ' stroke before the zero.

 

[smcadman]

If I use a ', the numbers are store as text instead of numbers. Thanks anyway.

Flores