running excell 2002.
I have a list of part numbers starting 1xxxxxxxxx (8 digits total) and
ending 9(4 digits). Default will put the larger number of digits last but I
need the first number of the sequence to be the primary sort number. eg:
12345678, 2345, 6, 789, 8, 99999. etc.
Any simple solution?