Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort mixed numbers/letters
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. |
#2
|
|||
|
|||
Sort mixed numbers/letters
See your other post
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "V-ger" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
SORT MIXED DATA | Excel Worksheet Functions | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |