Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting Issue. Please help
How can I sort by a row of numbers with mixed formats? I have numbers such
as 1, 2, 3 and 10, 22, 27 and 11-A, 20-D, 34-D etc. Currently, no matter how I format the cells, they sort by first number, then second, then the numbers with letters (1, 10, 2, 22, 27, 11-A, 20-D etc.). I can't seem to find a way to get the column to sort by the actual value (1, 2, 3, 10, 11-A, 22, etc.) Please...any help you can give me. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Issue | Excel Discussion (Misc queries) | |||
Major Sorting Issue | Excel Discussion (Misc queries) | |||
Sorting Issue (Mixde Fields) | Excel Discussion (Misc queries) | |||
An issue when sorting in excel PivotTable | Excel Discussion (Misc queries) | |||
sorting issue - help | Excel Discussion (Misc queries) |