CODEWITHSUNDEEP
sortingvalidationgoogle-sheetsdropdownstring-formatting
PythonNewbie
PythonNewbie

Reputation: 1163

How to sort by number in data validation

I have currently a problem where I am trying to filter based on numbers that I have put on in data validation:

Data validation

As you can see the numbers goes from 1 to 11 and when I am using the filter to sort A-Z, it goes by 1, 10, 11, 2, 3, 4, 5 ...

1-10

and I wonder how can I filter it by going numberic? meaning 1,2,3,4,5,6,7,8,9,10,11 ?

Upvotes: 1

Views: 154

Answers (1)

player0
player0

Reputation: 1

one way would be to use 01 prefix instead of 1

this would then sort:

01
02
10
11

Upvotes: 2

Related Questions