converting text into a date format

[iceordo]

Hi,
I have a problem conveting data into a date format. When i download date form a source, it gives me date information as "20121114". And when i change this into "11142012", it is still not recognized as date. I appreciate if anyone could me on this. Thank you

Best
Emre

[Kevin UK]

Hi Emre

Try separating your date with / or -. Or a function: =MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4) assuming your date is in A1.

[alansidman]

in a new column try this assuming your original date is in cell A3

=DATE(LEFT(A3,4),MID(A3,5,2),RIGHT(A3,2))

[iceordo]

thanks a lot. appreciated that