numbers in a column are not sorting ascending

  • Thread starter Thread starter slhiaz
  • Start date Start date
S

slhiaz

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.
 
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 said:
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.
Click to expand...


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.
 
Back
Top