View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ty ty is offline
external usenet poster
 
Posts: 19
Default sorting problem 10 comes before 8

When sorting a list in a column where some are single digits and some are
such as :
1
3
8
8 x 12
10 x 10
they sort as follows
1
3
8
10 x 10
8 x 12
single numbers are fine but once you hit the ones with the x (to show
measurements) the 1 in the 10 x 10 comes before the 8. It does not help to
make it text.
Any thoughts