Excel custom date formatting

Hi,

I am having an excel sheet that contains the date in the following format -

Jan - 23
Feb - 23
Mar - 23
Jan - 24
Feb - 24
Mar - 24

My expectation is that excel should consider 'Jan - 23' as 1/1/2023, 'Feb - 23' as 2/1/2023 , 'Mar - 23' as 3/1/2023. But instead, excel assumes the date as 1/23/2022, 2/23/2022,3/23/2022 and so on. How can I make sure that the date format is 1/1/2023 when 'Jan -23' is entered.

I tried to customize the date format by using the type as 'mmm-yy' and clicked 'ok' but it doesn't seem to be working for me.

excel1.PNG

Any help is greatly appreciated. Thank you in advance.

Regards
Sravya

Hi Marvin,

Thank you for your help. I think our dates are text. I added 20 in front of 23 i.e. Jan 2023 as suggested and it changed to Jan - 23 properly.


Regards
Sravya