At one time I thought I was able to do this by simply formatting the values correctly, but I am having no luck.



Is it possible to sort the following data numerically in a column...

100, 200, 300, 100A, 200A, & 300A

... with the following result.

100
100A
200
200A
300
300A


At present, when I sort this data it sorts as such...

100
200
300
100A
200A
300A

I am aware that there are ways to sort this by using formulas and "helper columns", but for my purpose that would just be ridiculously cumbersome.

Any help would be greatly appreciated!