xxxxxxxxxx
All you need to do is first type an apostrophe (') symbol
and then type the number.
So if you want the value in the cell to be 000123, you should enter '000123.
Adding an apostrophe converts the number you enter into text,
and the leading zeros don't go away.