Convert date dd.mmm.yyyy to dd/mm/yyyy

[James8761]

Hi,
I currently have dates in Cell D1 as text as 02.Apr.2017

I need to convert them to DD/MM/YYYY. Is this possible please?

 

[decadence]

You can use the Find and Replace function to Find the . and Replace with /, Or format the cells as a date

 

[James8761]

You can use the Find and Replace function to Find the . and Replace with /, Or format the cells as a date

Thank you,. Didn't think of that. Replaced them with a /