Sorting Issues

BTMarketingOps
✭✭✭✭
I have a column set up as a multi-select drop down with the numbers 1-30 and the word Carry Over as well. I understand that the sort function will sort on the first option which will always be the numbers but what I have an issue with is when I sort, it sorts the numbers 10+ after the number 1 instead of after the number 9. Is there any way around this?
Best Answer
-
I recommend adding 01, 02, 03, 04, 05
I use that numbering mechanism in any computer file-system environment.
Let us know if that worked!
Answers
-
I recommend adding 01, 02, 03, 04, 05
I use that numbering mechanism in any computer file-system environment.
Let us know if that worked!
-
Thank you, that worked!
-