I'd guess that your coercion didn't work right. I'd do it one more time.

If that column has nothing in it but what looks like numbers, you could test
before you start.

Put these formulas in a couple of empty cells:

=count(a:a)
and
=counta(a:a)

The top formula will show the quantity of numbers in column A.
the bottom formula will show the number of cells with something in it--number,
text, formulas, anything.

If that's not it, make sure you select the complete range before you sort.
Maybe you didn't include all the rows??????

If both of these don't help, maybe the data isn't what you expect. Are there
extra spaces or those HTML non-breaking spaces in the cells?

SG wrote:

Hello there,

I am having an issue with Sorting my data list.

I am having a list/ range which I would like to sort.
Whether I use the standard "sort ascending" button or I use
Data|Filter|autofilter instead (sort ascending) ... somehow my data
does not get sorted ascendingly.
It looks like, 1,1,1,1,5,5,5,5,57,7,1,4,4,4,4,4,4,4,4,12,....etc etc

I have a column labelled "Month" ... in which there appear only the
nrs from 1-12.
OK, it is some imported data from an Essbase system ... but I coerced
the data into real numbers by multiplying them with 1, as I though
tthat this could be the cause of teh problem.
Helas :(

OK, the data is like 30.000 rows long.
But hey, If I sort ascendingly or descendingly for that matter, on
some otehr fields it works!
I would think that sorting on numbers would be the easiest for excel,
but it does not seem to be true.

Anyone an idea why it bugs ? How to overcome it ?
Thanks in advance,
Jen

--

Dave Peterson