Dear all

I have a column of figures, simply formatted as 5, 4, 8, etc. and I need to
add several zeros to the front of each one, ie. 4 needs to be 00000004.

Is there any way i can do this without editing every cell?

Thank you
Louise