I have a bit of a love-hate relationship with Excel. I know it’s very powerful, but I really don’t know how to use it beyond the very basics. Today was one of those instances where I had a column of “numbers” in a spreadsheet that I wanted to sort, but Excel thought they were text strings. I wasn’t sure how to get Excel to truly treat them as numbers until I found this cool trick…
Here I have a spreadsheet with site sizes in column C. I wanted to sort them largest to smallest, but it was sorting them as text values instead of numeric values:
To change them into numeric formats, I can use the Text To Columns option (yeah, not very intuitive). I selected the entire contents of column C and clicked Data > Text To Columns:
In the wizard, don’t do anything but click Finish:
Now when I sort that column, I get a sort based on actual numeric values!