adding 0's to the left side of a constant number cell

[faisal alfadl]

adding 0's to the left side of a constant number cell

 

[Dave Peterson]

Try formatting the cell.

Select the range
format|Cells|number tab
custom category
000000
(as many digits as you need)