Sorting Issues

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

Answers