HI all,
I have some values such as:
Wed-11-Oct 06:29
Thu-12-Oct 11:37
These are manually entered as text. I would like to have excel recognise them as dates and times separately, as I have a column with dates such as 11/10/2006 (and I want to look for this date to see if they are the same). However I am having trouble converting this text into a date format (I have managed to create a separate column with the time component).
Any ideas?
Thanks
John
I have some values such as:
Wed-11-Oct 06:29
Thu-12-Oct 11:37
These are manually entered as text. I would like to have excel recognise them as dates and times separately, as I have a column with dates such as 11/10/2006 (and I want to look for this date to see if they are the same). However I am having trouble converting this text into a date format (I have managed to create a separate column with the time component).
Any ideas?
Thanks
John