Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help - sorting list of numbers
Hello,
I am not so good with using excel and nobody in my office can figure out what I'm doing wrong. I am trying to sort a list of folders first by Box Letter and then by Folder Number. I want my list to look like this: Box Folder A 1 A 2 A 3 B 1 B 2 B 3 and so on. But whenever I sort the information, the numbers are all out of order. My list looks more like 1, 10, 11, 12, 2, 21, 22, 3, etc. I know if I were to insert a 0 before each single digit number, it would sort correctly, however there are several thousand entries on this list and I don't want to go through and add several thousand 0's. I think it has something to do with the formatting of my columns, but I've changed it to everything available and still it sorts incorrectly. What else can I do? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter a list of numbers and blank cells | Excel Discussion (Misc queries) | |||
How to auto insert rows in a list of numbers | Excel Discussion (Misc queries) | |||
find sum in list of of numbers | New Users to Excel | |||
Create a new list that singles out duplicate numbers | Excel Discussion (Misc queries) | |||
making a list of numbers. | Excel Discussion (Misc queries) |