Sorting ten's before 2

[RASI]

Hi

These are numbers I need sorted:

1
12
2
5
20
7
13
8
9

But when I press Sort I get this:

1
12
13
2
20
5
7
8
9

What I wanted was this:

1
2
5
7
8
9
12
13
20

Whats my problem?

 

[Joe4]

I have a similar concern but it involves the dates

If you have dates entered as Text, you will have the same problem mentioned above.
Use "Text to Columns", as mentioned above, changing the data to Dates (and choose the "DMY" format option in Text to Columns), and it will convert them to valid dates.
Then you can sort as dates.