Hi All,

I am cetting an exchange rate table from an American Website. It uses the
american date format mm/dd/yyyy

As my PC is set-up to use the UK date format dd/mm/yyyy these dates are
stored as text when pasted to excel.

How would I convert these american dates to UK dates?

Thanks

Andi