Hi OfficeNDN,

Insert a helper column next to your 9 digit number. Say the 9 digit
column starts in B2 then in C2(which is your helper column) put
this formula =RIGHT(B2,6) and copy down as far as needed.
You now have two identical columns to sort on.

HTH
Martin