Prefixing a selection of cells with zeros

L

Louise

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
 
D

Duke Carey

Use a helper column adjacent to your values and use this formula

=text(a1,"00000000")

changing the A1 to reference the first cell in your list. Copy this formula
down to handle all of your numbers, then select all the formulas, Edit>Copy,
then Edit>Paste Special>Values
 
L

Louise

Thank you, I'll give that a go. It has also been suggested to try Format,
Cells, Number, Custom and ask it to enter 0000000 before each positive number.

Thanks again.
Louise
 
Top