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.
