How can I sort a list of numbers by the last 4 digits?

[Kristin S]

I have a list of numbers that are 6 digits long & I want to sort them
(ascending or descending) by the last 4 digits. Is this possible?

 

[Chin via OfficeKB.com]

Kristin,

One method is to insert a dummy column with formula =right(A1,4)
Then use the sort function to sort the dummy column in ascending or
descending order.
Please advise if this works.