sorting a series of nos. on basis of digits
Select the column of numbers and pull-down:
Data Sort...
Then select whether you want to sort ascending or descending. This works
because numbers with more digits wil be larger than numbers with less digits.
For example:
1 is less than 10
20 is less than 100
100 is less than 1000
1000 is less than 10000
--
Gary''s Student - gsnu200715
" wrote:
Dear All
Can anyone suggest me how do I sort a sequence of nos. on the basis of
no. of digits.?
For eg. I have a column with 9 digits and 10 digits nos. collectively.
I wanna sort them on the basis of no. of digits.
(i.e. 9 digits separately and 10 digits separately)
How do I proceed further?
Best Wishes
Asad
|