Try applying a custom number format.
Format|Cells... choose the Number tab. Click on Custom and enter as
format 000000
(or as many digits as you want).

HTH
Kostis Vezerides