Column Sorting Place position 1-2-3-33-4-5-6 sorts 33 after 3 not after 6

[HP_ELITE_8300]

column of numbers sort by position not by value

1

2

3

33

4

5

6  should sort 33 after 6 not after 3

[#2]

@HP_ELITE_8300 Your "numbers" are in fact texts. So, the text "33" gets sorted after "3" and before "4". You can do a Custom sort, chose A to Z and press OK. Then you should get a warning message saying that you have texts that look like numbers with a question what to do with it.

Alternatively, transform the texts to real numbers.