Try formatting the cell.

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

faisal alfadl wrote:

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

--

Dave Peterson