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!!
|