0 preceding numbers
0 preceding numbers
(OP)
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
How can I have the 0 precede the other 5 numbers?
Flores





RE: 0 preceding numbers
TTFN
RE: 0 preceding numbers
Flores
RE: 0 preceding numbers
RE: 0 preceding numbers
Flores