Getting a text year date to be recognised as a date

hi all
I have data (column M) entered as a year in text format ie the text says "2020". I need to get Excel to recognise that text as a date (eg yyyy) for use in other formulae but if I convert it Excel recognises it as 1905 in date format-presumably because it is changing it to a serial number. The year 2021 in text also changes to "1905" when converted as does 2019 etc (see attached screenshot). Is there a formula I can use to convert the text to a date but also have it record the same as the text says eg so that the text says 2019 and the cell that holds that as yyyy in date format also shows and recognises the data as 2019? Snip.PNG

hi Ali
unfortunately I am not in control of the data being entered into column M. It comes to me as data from an external survey tool which I then paste into the spreadsheet to analyse.

hi Ali, that works perfectly-thank you so much!!