View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default 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!!