Convert Text String to Date - Please Help!

[Steve_AL]

I have cells with text string

Jan 02 2014
Dec 12 2014

etc

I need to convert them to date format and have tried everything.

Can anyone help?

Many thanks.

 

[VBA Geek]

datevalue(replace(a1,7,1,", "))

 

[Chrisdontm]

Highlight what cells you want set as date, right click, choose " Format Cells ", choose far left tab, go down and choose "Date ", on the right choose which way you want it laid out, click OK...

 

[Steve_AL]

Tried that,
Doesnt work I am afraid.

 

[Chrisdontm]

2-thoughts...
Is there text in that cell with the date...?
Also, could you delete that column and insert a new one..?