Change the number of charaters in a cell by adding a zero to the beginning

[Guest]

I have a column with a mix of eight and nine character lengths. I need to add a zero to the beginning of the eight character cells. I tried nine zero's in the custom format with no results.

Thanks

 

[Jim]

Select all the cells and Format>Cells>Custom>000000000>OK. You cannot simply
"add" a zero to the left (front) of the number. Oh, I suppose you could
concatenate...

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

I have a column with a mix of eight and nine character lengths. I need to

add a zero to the beginning of the eight character cells. I tried nine
zero's in the custom format with no results.

 

[Peo Sjoblom]

If that doesn't work then you must have text numbers, copy an empty cell,
select the numbers
do edit>paste special and check add.Now use a custom format like 000000000

--

Regards,

Peo Sjoblom

I have a column with a mix of eight and nine character lengths. I need to

add a zero to the beginning of the eight character cells. I tried nine
zero's in the custom format with no results.