View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] mathew345@gmail.com is offline
external usenet poster
 
Posts: 1
Default List Sorts Numbers By First Digit, Rather Than The Whole Number.

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?