Give us some examples of your data, and how you want it all to sort.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"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?