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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Peter said:
I have a column with a mix of eight and nine character lengths. I need to
Click to expand...
add a zero to the beginning of the eight character cells. I tried nine
zero's in the custom format with no results.
 
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


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