hi all
I have loads of data next to dates that are in the following format
10Jan2005:06:02:31
I was hoping to turn this into the usual 01/10/2005 format, and for it to be recognized by excel as that date.
An ideas - this is driving me up the wall!
thanks
Jordan
I have loads of data next to dates that are in the following format
10Jan2005:06:02:31
I was hoping to turn this into the usual 01/10/2005 format, and for it to be recognized by excel as that date.
An ideas - this is driving me up the wall!
thanks
Jordan