Sorting a column with numbers and letters!

[krazykevin76]

Have a column of data with entries as such:

OCT14 1
OCT14 2
OCT14 3
OCT14 10
OCT14 11.......
MAR15 1....and repeats like the OCT14 above.

When sorting these, I have two issues. It puts the MAR entries before the OCT, because of the letters, so I'm looking for a fix for that. Then when I filter for say just the OCT entries, I have the issue of the 10, 11, and 12 going before the 2. So its
1
10
11
12
2
3

Is there any way to get around this without creating new columns? And if not, what would be the easiest way to do it?

Thank you

 

[RonB1111]

This formula requires a new column and converts data in A2 to Excel "Date" format:

=--(--RIGHT(A2,2)&"-"&LEFT(A2,3)&"-"&"20"&MID(A2,4,2))