Sorting numbers the common sense way excell03

  • Thread starter Thread starter dlaplant
  • Start date Start date
D

dlaplant

How do I get these rows sorted numerically

1705
17350
20028
20028
2053
220
3839
4077
4077
4646
4673
4673

as you can see it is sorting by the first digit without regard to its actual
value. This is totally frustrating.
 
Convert your data from text to numbers. You can do either:

a) Use a formula like this:
=VALUE(A2)
and sort by this, or do a Copy, Paste Special - Value

b) Input 1 into a cell, copy it, then do a Paste Special - Multiply
onto you data.
 
A real solution to this is:
put this formula beside the data, and drag it: =len(A1) for instance. in
column B, then select both columns, and sort by column B. That's it.
 
Back
Top