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

I am using Excel 2003. Can I sort a list of numbers by the last four digits?
There are apprximately 6 digits in each number.

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

The easiest way would be to create a helper column and perform your sort
using that.

Let's assume your original data is in column A and your new helper column is
column B. In column B enter the formula:

=RIGHT(A1,4)

Copy down as needed. Then, when you sort, use Column B.

HTH
Elkar


"Kristin S" wrote:

I am using Excel 2003. Can I sort a list of numbers by the last four digits?
There are apprximately 6 digits in each number.