Sorting 1, 2, 10, 20 to 1, 10, 2, 20
 

I am trying to sort a list of articlenumbers, example:
1, 2, 10, 22, 202.

I want to sort it like: 1, 10, 2, 202, 22.

Can anyone tell me how to do that?

Thank you in advance!!

Sorting 1, 2, 10, 20 to 1, 10, 2, 20
 

since it isn't sorting them that way as the default, then I assume they are
stored as numbers rather than text. In an adjacent column, put in a formula
like (assume the first number is in B2)
C2: =Text(B2,"#")
then drag fill down the column.

Select the rows you want to sort and sort your data using column C as the
sort key.

--
Regards,
Tom Ogilvy

"Caroline" wrote:

I am trying to sort a list of articlenumbers, example:
1, 2, 10, 22, 202.

I want to sort it like: 1, 10, 2, 202, 22.

Can anyone tell me how to do that?

Thank you in advance!!

Sorting 1, 2, 10, 20 to 1, 10, 2, 20
 

Hi Caroline,

Say your data is in column A.
Insert a helper column and in B1 put ="."&A1 and drag
down to the end of your data, this will convert it to .1, .2, .10,
..202 etc.
Then sort on column B ascending, and then delete column B

HTH
Martin

Sorting 1, 2, 10, 20 to 1, 10, 2, 20
 

Use a helper col to change the numbers to text, then sort both ascending by
the helper col using "Sort numbers and numbers stored as text separately"

Assuming source numbers in A1 down
Put in B1: =A1&""
Copy down
Then select both cols A and B, sort by col B ascending Sort numbers and
numbers stored as text separately OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Caroline" wrote:
I am trying to sort a list of article numbers, example:
1, 2, 10, 22, 202.

I want to sort it like: 1, 10, 2, 202, 22.

Can anyone tell me how to do that?

Thank you in advance!!

Sorting 1, 2, 10, 20 to 1, 10, 2, 20
 

Convert the numbers to text
=TEXT(A1,0)
Then you can sort as text.
--
David Biddulph

"Caroline" wrote in message
...
I am trying to sort a list of articlenumbers, example:
1, 2, 10, 22, 202.

I want to sort it like: 1, 10, 2, 202, 22.

Can anyone tell me how to do that?

Thank you in advance!!

Sorting 1, 2, 10, 20 to 1, 10, 2, 20
 

Thank you!
My boss will love me :-)

"Max" skrev:

Use a helper col to change the numbers to text, then sort both ascending by
the helper col using "Sort numbers and numbers stored as text separately"

Assuming source numbers in A1 down
Put in B1: =A1&""
Copy down
Then select both cols A and B, sort by col B ascending Sort numbers and
numbers stored as text separately OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Caroline" wrote:
I am trying to sort a list of article numbers, example:
1, 2, 10, 22, 202.

I want to sort it like: 1, 10, 2, 202, 22.

Can anyone tell me how to do that?

Thank you in advance!!

Sorting 1, 2, 10, 20 to 1, 10, 2, 20
 

Good to hear that, Caroline <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Caroline" wrote in message
...
Thank you!
My boss will love me :-)