How to add a leading zero

[Peter]

Hi

I have a column of numbers - (telephone numbers actually) and I need
to add a leading zero to each one.

Is there an easy way of doing this other than converting each number
to text and adding the leading zero manually?

--
Cheers

Peter

Please remove the invalid to reply

 

[Bernard Liengme]

Use Format Cell | Custom format such as 000000000000000 (as many as are
needed)
best wishes

 

[Rick Rothstein \(MVP - VB\)]

I have a column of numbers - (telephone numbers actually) and I need

to add a leading zero to each one.

Is there an easy way of doing this other than converting each number
to text and adding the leading zero manually?

You can apply a format to your entire column. Click the column header to
select the entire column, right-click that selection and select Format Cells
from the popup list, then select Custom from the Category list, and type
00-000-000-0000 in the Type field (I am presuming you want your telephone
number to look like I have indicated; otherwise, shape the format string as
you need) and, finally, click OK to finish the process off.

Rick

 

[Guest]

apply a custom number format

000-000-0000

would be the way in the US.

Just to be clear, the numbers do not now have a leading zero. They are just
displayed with a leading zero where appropriate.

 

[Peter]

Hi

I have a column of numbers - (telephone numbers actually) and I need
to add a leading zero to each one.

Is there an easy way of doing this other than converting each number
to text and adding the leading zero manually?

Thanks to all that were kind enough to reply - your formatting
suggestion worked perfectly - exactly what I wanted!
--
Cheers

Peter

Please remove the invalid to reply