ExcelBanter - View Single Post - List Sorts Numbers By First Digit, Rather Than The Whole Number.

Bruce Sinclair

In article . com, wrote:
Hello,

I am inputing some football statistics into an excel sheet, and I am
having some problems with sorting. I have my data in a list, with
filters at top. I am using the filters to sort the data, and all was
going well until I saved the workbook. Now, when I use the filters to
sort, the values are being sorted by the first digit only.

Example: the following numbers 1, 2, 3, 4, 5, 10, 20, 30, 40, 50 would
sort like this

1
10
2
20
3
30
4
40
5
50

I have all the cells formated as numbers, I have tried formatting them
in different ways but to no avail. Any suggestions?

Sorting and filters are different things. Are you saying that if you turn
the autofilter on, you see 1, 10, 2, 20 ... etc ?
I just tried numbers and text and the autofilter order in bothe cases was
smallest to largest.
This suggests to me that something else is going on. Did you type in the
numbers or import them from a file ? As you suggest, that sort order implies
text rather than numbers if you are talking about a sorted list rather than
autofilter. Suggest that there might be some non printing characters in your
data. The other option is possibly a 'custom list' that specifies that sort
order. Check those out.

HTH