Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!
So a guy here has an Excel file that has data in 2 columns. Column the first is the model of the unit sold, and the second column is the serial number of the unit. When he tries to sort it by serial number however, one row will not sort. We tried all sorts of things, moving the row to another location at the end or middle of the list. Changing the data type in the cells from general to number. Deleting the data which had been copy/pasted in from a Google spreadsheet and hand entering. It would always just leave that row where it was. The only way we could get it to sort that row, was to remove the 'T' from the end of the model number.
Anybody know why the heck Excel would refuse to sort a row where the data in the cell in the column not being sorted by has a 'T' at the end?
edit: the other model numbers are a mix of 3 digit numbers, and 3 digit numbers ending in other letters, such as K or D. Those work fine.