Covert 9 digits to 10 in excel

L

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?
 
M

MartinW

Hi Lisa,

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

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

HTH
Martin
 
S

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:
 
Top