Paul .G

Help!

I need to format a load of data which has got a date/time column but it is in the US format mm/dd/yyyy, so some functions within the pivot tables wont work.
e.g. 07-25-2004/06:22:32

I need to convert the date to UK format, if needed I can seperate the date and time using text to columns or is there any way to set just one workbook to US date format.
I dont want to have to mess round with the regional settings all the time.

Any one a wizz with excel/VBA ??

Paul .G

Nearly, that only changes the format where it is obviously wrong, it does not change it where the date could be right in either format.

I have managed to sort it another way.

Thanks anyway

Paul