numbers in a column are not sorting ascending

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.
 
E

Eduardo

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
 
G

Glenn

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.


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top