I have 1 column with "item numbers" Which can be both numbers and
letters.
I wan't to sort them as numbers so that all numbers would come 1st and
then item numbers like KK1992991. The thing is that excel seems to
treat all cells like text fields, even thought I have formatted them as
number fields.
Now excel i.e. sorts 101 before numbers 11-99. I you get what I mean
:P.
Excel would sort cells ,1, 2, 10, 101, 111, 121, 399 like:
1
10
101
111
121
2
399
So how can I make excel understand I want it sort them like numbers :o
-Sirritys
Bookmarks