- last edited on
I have a spreadsheet with about 10000 rows of data that looks like this:
The third column is text (istext reports TRUE). I'm trying to sort by that column but 15E10 sorts before 01A10. Why would it do that? And how can I make it sort normally? The sheet is attached.
Help would be appreciated.
Goto Sort & Filter -> Sort -> Column Precinct - Sort on Values - Order A to Z.
Click OK and you get a warning. Select the second option. Click OK.