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