Hi,

Reletively new to VBA but learning quickly!!!

I have inherited some sheets which contain data exported from an SAP based system. The data is cool however all dates are exported as a string in the form dd.mm.yyyy. I need to convert these columns(3 columns C,F and I) of "string dates" to date formats dd/mm/yyyy, 3 columns C,F and I.

Am able to do this outside of VBA i.e in the sheets themselves with Formulae etc.. but need to encorporate this conversion in a VBA routine.

Please help, have come un stuck as any attempts seems to return a mixture of dd/mm or mm/dd.

Cheers