Turn into recognizable date format

[Jordie]

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

 

[Seti]

Have a look at Data|Text to Columns. Set to delimited on the colon, make sure you set the first chunk of data to Date|DMY and ignore the other columns.

Post back if you need more direction.

 

[Jordie]

Your a genius - quick and painless!

Thanks

 

[Seti]

Your Welcome. Glad to help.