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?