Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting excel data
hi everybody,
my question is as follows, i'll try to explain it using a current situation I've had. I've created a semi-numerological list (numbers with other characters), consisting of the following data: 60000-1 60000-2 60000-3 60000-4 60000-5 60000-6 60000-7 60000-8 60000-9 60000-10 60000-11 60000-12 If you let excel sort this dataset (even if you format the cells as numbers), it sorts as follows: 60000-1 60000-10 60000-11 60000-12 60000-2 60000-3 60000-4 60000-5 60000-6 60000-7 60000-8 60000-9 Is there a way to let excel sort this dataset correctly (as the top list, that means)? thanks in advance, Leon van Gurp |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data sorting | Excel Discussion (Misc queries) | |||
Sorting data in excel | Excel Worksheet Functions | |||
Excel Data Sorting | Excel Discussion (Misc queries) | |||
Sorting Excel Data | New Users to Excel | |||
Sorting data in Excel.. | Excel Worksheet Functions |