AutoFilter does not arrange numbers correctly

[Tumoz]

Hey!

My excel table has numbers between 0-15000, I would like to arrange these from smallest to largest, but the sort does not work correctly.


When i use "sort A to Z", I get the results in order like:
1
100
11000
2
210

My data is in table (with headers) and i am trying to use AutoFilter.
I have Excel 2013.

 

[Hindustani]

Your data is stored as text. Convert to number before sorting.
I assume the data is huge and hence the easiest way to convert it to numbers would be to multiply by 1. Put the number "1" in some empty cell, then copy that cell. Select all the cells you want to convert, then Paste Special -> Values, Multiply. This should convert all values to number.

 

[Tumoz]

Thanks for the fast reply, this solved my issue! Big thanks!