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

New Contributor

column of numbers sort by position not by value

1

2

3

33

4

5

6  should sort 33 after 6 not after 3

1 Reply

@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.