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.
 

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

Similar Threads

how to sort number properly in excel? 5
Sorting in Numerical Order 4
Numbers to sort as text 5
Sorting within Rows 7
How do I sort by the first digit of a number? 7
Sorting List of Numbers 4
sorting hyphenated numbers 3
List Sorts Numbers By First Digit, Rather Than The Whole Number. 3

Back
Top