I need to sort like this

1
5
90
90a
90b
100
170a
170b

instead of
1
5
90
100
90a
90b
170a
170b

I found a message from 2006 that said to do this:

"I'd convert the column to Text. (Data-Text to Columns...)

Then, sort, making sure to check "Sort number and numbers stored as
text separately."

I did what was suggested and got this:

1
100
170a
170b
5
90
90a
90b

So, how do I get it to sort the way I want? (the numbers go up into the
1000's)
--
Ginger Kohler