Adding a year to a date

[Davidns]

I have exported a file and there is a column that returns dates as text in the following format - 01/19.

I need to append "2017" to every entry in that column so that the result is "01/19/2017". What would be the best approach to doing so?

Thanks!

 

[mrshl9898]

Is the value a text or a number?

If you want it as a date, then assuming the text is in A2: =DATE(2017,RIGHT(A2,2),LEFT(A1,2)