So I'm trying to sort a list that includes columns of time names, etc and one includes distance, a number value. I select the whole data I want to sort, click on 'Sort' under 'Data', and a dialog box opens with 'Sort by' I select column J where the distance number value is, leave 'sort on values', and then 'order' I change from A-Z to Z to A so it will sort largest first, click OK and it sorts, but by the first number. That is it will sort 1000 above 60. How do I make it sort by the actual number value, larges one first, not the largest first number first. This is idiotic, don't think I've had this problem before. Now I'm importing this data from WSPR.net from the web site, so there are blank spaces in the numbers, but that shouldn't make any difference. I know sometimes I have to replace all those blank place holders with actual blank space, but I've tried that and it still sorts by largest first number, not by actual value????