Changing year format from two digit to four digit

[Closed]
Report
-
Hello,

I have data in three columns containing dates that have two formats; some display as dd/mm/yy and others display as dd/mm/yyyy. I need the four digit year, but nothing I've tried changes the existing data from 2 digit years to four digit years. Any ideas on how to correct this?