Add a leading zero

[Dave Peterson]

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]

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

 

[yahoo]

as long as the number stays in number format

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)

 

[Dave Peterson]

Then you should be fine.

What happened when you tried it?