You would get that sort order automatically if the "numbers" were text
digits instead of numbers. If there is no reason that they need to be
numeric, then in an empty column use a formula like =A1&"" to coerce to
text. Then copy and Edit|Paste Special|Values back into the desired
location.

Jerry

Andyd wrote:

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?