0 preceding numbers

smcadman · Aug 8, 2005

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 · Aug 8, 2005

Create a custom format with leading zeros "000000"

TTFN

smcadman · Aug 8, 2005

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

Flores

quark · Aug 11, 2005

Simply, put the ' stroke before the zero.

smcadman · Aug 13, 2005

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

Flores

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

0 preceding numbers

smcadman

Mechanical

IRstuff

Aerospace

smcadman

Mechanical

quark

Mechanical

smcadman

Mechanical

Similar threads

Part and Inventory Search

Sponsor