If you are only concerned about how it looks (not changing the value), you can
give that cell (column of cells???) a custom format:

Select the column
format|cells|number tab|custom
00000
(as many 0's as you want digits to display)

yahoo wrote:

I have a column of numbers.
I need to place a zero in front of them
Instead of doing each cell manually - is there a way excel can
automatically place a 0 in front of them number?
Thanks

--

Dave Peterson