Struggles with Numercial Sorting. Please Help.

[mtbakerstu]

Hello,

I'm struggling with a numerical sort using Excel 2000, though I suspect
this issue is universal to all versions. I want to sort like so:

1
5
7
11
22
111

Alas, when I format by "Number", I get this sort result

1
11
111
22
5
7

Nothing new here under the sun, but I'm sure there's an easy formula
for getting this to sort in a true numerical order.

Anyone with any insight into this, please advise.

Thanks, mtbakerstu

 

[Guest]

Hi
Works fine for me.
What cell format are you using. I notice your numbers are left justified
which usually means it is formatted as text, and that may be your problem.

HTH
Michael M