Hi I am new to this forum so I apoligize if this question has already been answered.

My problem is that I am working with a dataset where the date has been entered 09-Mar, Excel "thinks" the 09 is referring to the day when it is actually referring to the year. Is there a way that I can transform the 09-Mar to Mar-09 so the date can be correct.

Thank you in advance for your time.