I have a column of dates in an excel spreadsheet in the format 05-04-06. How
do I the change dates to 05/04/06.

I have tried formatting the cells but this does not work. Does anyone have a
formula that can be used please?