Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
How do i set up a list that sorts as Number/letter/number in orde | Excel Discussion (Misc queries) | |||
Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
I wish to change the last digit in a list of random numbers. To a. | Excel Worksheet Functions |