Forum Discussion
sort numers
hi i would like to know how i can sort the numbers, 1 to 1000. if I put them in excel in there in any order. my problem is if I push, the sort button, it will sort so 1 and 10 and 100 is together with...
ok so what you say is that, what to me looks like numbers, are not?
Here
in A1 is text (number stored as text), by default it aligned to the left. In A2 is number.
I guess in your case all are texts, to be sure it is better to check sample file.