Thread: Number Sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darren Darren is offline
external usenet poster
 
Posts: 137
Default Number Sorting

I have a list of part numbers in a column which I need to sort

When I use the sort function in excel, it will sort them according to their
number size, ie.

31, 41, 311, 411

I need them to read as

31, 311, 41, 411

How on earth do I do this?