8 digit number - Convert to Date Formate

I have a column with over 1000 entries in a 8 digit number format, which should represent a date.
e.g 20050214
should represent 14th February 2005,
or even 2005-02-14

However I have no luck in converting all these entries using the formating option to represent at date. Unless I manually input a "-" between 2005 02 14

Please advise!

use something like either one of these in a seperate column and then copy paste the result over the original column:

=DATE(YEAR(INT(LEFT(A1,4))),MONTH(INT(MID(A1,5,2))),DAY(INT(RIGHT(A1,2))))

=(LEFT(A1,4)&"-"&MID(A1,5,2)&"-"&RIGHT(A1,2))

assuming your string date is in cell A1. Drag down to copy for the rest of the cells

Mangesh

=(LEFT(F938,4)&"-"&MID(F938,5,2)&"-"&RIGHT(F938,2))

done the trick Mangesh ! You are the man! Respect!