sorting a series of nos. on basis of digits
 

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

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