Hi,

I have a system that exports all data into Excel in US date format (i.e.
mm/dd/yy), but as my customers are using UK formatting I need to convert
these dates to UK format (i.e. dd/mm/yy).

Can anyone help me with a macro or formula to assist me converting these?
There are SO many cells I need to convert doing it manually is not a feasible
option.

Thanks in advance,