VBA to change US date format to UK date format

[Apple08]

Hi everyone

I have a report which have dates in American format YYYY-MM-DD, I need to change the date columns from D to M into UK format DD-MM-YYYY and the end row is various. Some fields may be only text instead of dates.

Please could anyone help how to create this in VBA? Many thanks.

 

[MARK858]

You're welcome. Btw, I don't consider myself an expert