Try sorting the list on an adjacent helper col

Assuming the list is in col A, A1 down

Put in B1: =TEXT(A1,"@")
Copy down

Then sort both cols A and B by col B Ascending

This should return the results ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Connie Martin" wrote in message
...
How do you sort a list of hyphenated and non-hyphenated numbers so that
2079-1 comes before 2121?

Connie Martin