Converting a 12-digit number to a 10-digit number

Is there a formula available that I could enter in a cell that would then allow me to scan in a 12 digit number into that cell and have the formula drop the first and last digits so that I'm left with a 10-digit number?

The first digit is always a 1. The last digit is random. I just need some method of getting the middle 10 digits to show in the cell...

Any help would be greatly appreciated.

Thanks,
Peanut

use the MID function. If your number is in cell A1, then enter this formula in cell B1:

=MID(A1,2,10)

Use this function to make it be a number again (the previous furmula would return the result as text.

=VALUE(MID(A1,2,10))

Thanks DaveyDave.... Just what I was looking for....