Nov 17 2020 02:09 AM
Nov 17 2020 02:35 AM
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.
Nov 17 2020 07:14 AM
Nov 17 2020 11:26 AM
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.