Prefixing a selection of cells with zeros
 

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

Prefixing a selection of cells with zeros
 

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, EditCopy,
then EditPaste SpecialValues


"Louise" wrote:

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

Prefixing a selection of cells with zeros
 

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

"Duke Carey" wrote:

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, EditCopy,
then EditPaste SpecialValues


"Louise" wrote:

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