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...
There are texts in your column, not numbers, and they are sorted as texts. If you need numbers, not texts, convert them to numbers first. On ribbon Data->Text to Columns, after that by default.
Plus be sure yor decimal separator is dot and column A is in General or Number format.
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.