Hi Sonya
the only way i know is to use a "helper" column, in a column adjacent to
your current column type
=VALUE(RIGHT(A1,6))
where A1 is the cell reference of the first 10 digit number
and fill down
now sort (Data / Sort) using the helper column as the sort field & delete it
when finished
hope this helps
Cheers
JulieD