Excel Sorting of Text
Posted on 2013-10-23
I imported a 14000 rows of data into an excel spreadsheet and want to sort by column A which has numbers anywhere from 3 digits like this: 019 and 5 digits like this: 47384. Some have this too: 0003a.
I had to import this column as text so that excel wouldn't mangle all the data and leave my leading zero's alone (why on earth does it do this).
Anyways - I can't sort it now. Custom sorts don't work either. I tried to sort it like this; 000,111,222,333, etc all the way up to 99999.