Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I can not get the following to sort correctly,
1 7 3 22 x 8 10 x 17 8 x 11 when I sort these they do as follows 1 3 7 10 x 17 22 x 8 8 x 11 it does fine with the single digits but as soon as there are others it sees the 10 as a 1 and a 0 so it puts this one before the 8. Changing them to text does not help. I believe it is in the format but I can't quite figure it out. Thanks, ty |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A Sorting Problem | Excel Discussion (Misc queries) | |||
Sorting problem | Excel Discussion (Misc queries) | |||
sorting problem | Excel Worksheet Functions | |||
sorting problem | Excel Discussion (Misc queries) | |||
Sorting problem | Excel Discussion (Misc queries) |