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

[Michael M]

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

"mtbakerstu" wrote:

> 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
>
>