Covert 9 digits to 10 in excel

[Lisalala]

I have a series of numbers in an Excel column. Some are 9 digits long and
need a zedro added to the front to make them 10 digits. I know there is a
formula I can place in a column next to them which will convert them but I
don't know what it is. Can anyone help?

 

[MartinW]

Hi Lisa,

Try this.
=TEXT(A1,"0000000000")

You could also apply a custom format of 0000000000
to the existing cells.

HTH
Martin

 

[Stefi]

If you want only to display leading zero, then custom format the cells with
format code "0000000000" (ten zeros). If you want to store 10 digit numbers
as text (e.g. a kind of codes) then enter =TEXT(A1,"0000000000") in an empty
helper column (adjust cell reference A1 to your real situation), copy the
helper column and PastSpecial/Values it back to the original column!

Regards,
Stefi

„Lisalala†ezt írta: