Prev: Sum Indirect
Next: Repeating rows not wanted
From: slhiaz on 6 Apr 2010 09:22
I am working in an Excel 2007 spreadsheet and one very long column of normal
numbers are not sorting. for Example:

407
408
102
103
104

Everytime I try to sort this ascending, it does nothing.
From: Eduardo on 6 Apr 2010 09:57
Hi,
Try this in another column enter

=Trim(A1)

I assume column A is where you have that numbers, then copy as value on top
of the others an sort it

"slhiaz" wrote:

> I am working in an Excel 2007 spreadsheet and one very long column of normal
> numbers are not sorting. for Example:
>
> 407
> 408
> 102
> 103
> 104
>
> Everytime I try to sort this ascending, it does nothing.
From: Glenn on 6 Apr 2010 10:13
slhiaz wrote:
> I am working in an Excel 2007 spreadsheet and one very long column of normal
> numbers are not sorting. for Example:
>
> 407
> 408
> 102
> 103
> 104
>
> Everytime I try to sort this ascending, it does nothing.


Are these "actual" examples, or just something that was easy to type? Are they
not sorting at all, or not sorting the way you expect them to? It's possible
that you have text that looks like numbers. They would sort like this:

1
11
111
12
122
13
133
14
144
2
3
4

instead of like this:

1
2
3
4
11
12
13
14
111
122
133
144

To convert your data to actual numbers, you can enter the number 1 in a blank
cell, copy it, select all of your data, then Edit / Paste Special / Values /
Multiply / OK.

Then try sorting again.
 | 
Pages: 1
Prev: Sum Indirect
Next: Repeating rows not wanted