M
mathew345
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?
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?