Convert text to date

[stevejpearson]

Dear all,

I am exporting data from an educational piece of software into excel but unfortunately it exports dates stroed as text. I am hoping that someone has an easy way to convert this text into a recognisable date format in excel.

The file to download i here http://www.box.net/shared/i7s27nmxc4 with the dates stored as text in column K

Thanks

Steve

 

[VoG]

Try

=DATEVALUE(K4)

and format the result cell as Date.

 

[VoG]

Alternatively, select the dates, Data > Text to Columns, tick Delimited, click Next twice, tick Date and select DMY then click Finish.

 

[stevejpearson]

Thanks.....that really was quite simple........but very effective!

Steve

 

[stevejpearson]

Mmmmm thought it was simple.....why doesnt it seem to work on this document.......does it only work in 2007 perhaps?

http://www.box.net/shared/eg3jrzfdhy

Steve

 

[VoG]

Data > Text to Columns works on that data.

The cell containing the DATEVALUE formula was formatted as Text so it displayed the formula. Change the cell format to General, Press F2 then Enter, and format as a Date.

 

[stevejpearson]

Thanks so much..........

Steve