A client has a spreadsheet which was sent from the US, and therefore a column of date entries are in the format of US type ie:
02/30/05 ie 30th feb 2005
I want these to be changed to the UK version ie:
30/02/05
However as regional settings are set to UK, Excel does not recognize 02/30/05 as a date in the first place, and does not convert it to a UK format accordingly. Also, despite formatting the column for date it still does not work.
I tried switching to a US locale, hoping that Excel would then recognize 02/30/05 as a date, and then back to UK again but this did not work.
He has several thousand entried in this format so its too much to change manually.
Any ideas?
02/30/05 ie 30th feb 2005
I want these to be changed to the UK version ie:
30/02/05
However as regional settings are set to UK, Excel does not recognize 02/30/05 as a date in the first place, and does not convert it to a UK format accordingly. Also, despite formatting the column for date it still does not work.
I tried switching to a US locale, hoping that Excel would then recognize 02/30/05 as a date, and then back to UK again but this did not work.
He has several thousand entried in this format so its too much to change manually.
Any ideas?
Comment