I have data that has already been created, and can be exported into Excel for sorting. The data in the cells is in this form: Blue Widget 1, Blue Widget 2, Blue Widget 3 and so on up to 300. (The spreadsheet lists many, many different types of items, all numbered.) Excel sorts alphabeticaly so it puts them in the following order 1, 10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 11, 110 etc. I understand that if the data had been created with leading zeros it would sort properly, but that is not the case. Can anyone help please?
2007-02-26
18:09:24
·
4 answers
·
asked by
BurblyOne
1