I have a spreadsheet that contains a column for the date. Some users input
the date as: 23/10/06, some as 23.10.06 some as 231006 and some as 23-10-06

Is there a way that no matter how they enter it, it will be accepted and
converted to the 23/10/06 version?