Sorting numbers the common sense way excell03
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.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"dlaplant" wrote:
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.
|