You can enter the numbers with an apostrophe in front of them, like:

'012345

The apostrophe will not show in the cell - this tells Excel to treat
the cell as text.

Or, you could pre-format the cells as text before entering your
numbers.

Or, you could apply a Custom format to the cells, set as "000000" -
the numbers will be treated as numbers and can be used in
calculations.

Hope this helps.

Pete

On Oct 20, 3:27*pm, mccomb wrote:
I have a group of 6 digit numbers starting with "0". *When I enter this in
the cell, it shows up in the cell correctly. *BUT up above the 0 gets
dropped. *I need the 0 to stay there. *What can I do so the 0 does not drop
off in the top box.