Hi Lisa,

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

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

HTH
Martin


"Lisalala" wrote in message
...
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?