As I understand it, you want to sort by the last (terminal) digit first.
Regardless of whether I understand this correctly, the way you get Excel to sort
properly is to create a column of cells which are ordered properly (many people
in this board call this a "helper column").

For example, insert a column after your SSN. Use a formula like:

=right(a1,9)&left(a1,8)

or whatever formula will allow Excel to sort the records the way you want. Then
sort on this column. You can hide the column if you don't want it to appear on
any reports.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"postitnote" wrote in message
...
I work in a medical records office and we are attempting to combine five
years' worth of records onto one spreadsheet. Our office uses Terminal Digit
Order (or TDO) and it doesn't appear that Excel can sort this way as it is in
order with the last four digits, then the middle two, then the top three.
Does anyone know if there is a way to do this without having to put the SSN
in three separate columns and then merging the columns together somehow?