Turn into recognizable date format

Jordie

Board Regular
Joined
Feb 3, 2005
Messages
58
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
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Seti

Well-known Member
Joined
May 19, 2002
Messages
2,916
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,287
Messages
5,571,318
Members
412,382
Latest member
Langtn02
Top