Omitting numbers

[jkktx81]

I have a column of 9 digit numbers. So I can do a match with another string of numbers I need to remove the first digit of that 9 digit number.

829583283 to 29583283

Since this column is very long it wouldnt be pratical to remove each one, one at a time.

Can I use the special formatting to remove the first digit from all in that column, and how??

 

[shg]

You could use a formula in another column:=MOD(A1,100000000)

 

[pagrender]

Another Option: =RIGHT(A1,8)*1

 

[jkktx81]

Thanks....