Please help - sorting list of numbers
It's because your numbers are formatted as text. Simply doing a
Format-Cells-Number doesn't fix unfortunately. Follow these steps to get
it working:
Copy an empty cell
Select your range of numbers
Right click choose "Paste Special"
Select "Add" and hit OK
--
Regards,
Dave
"ivoryblue1" wrote:
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?
|