Date-format

Hello,

Im on Excel 2007 and I have a problem with the dates.

In my raw data I have one column with dates in the form of 20101030 (text format). Normaly I would just put - between year, month and day (2010-10-30).
But, in this document I have 7500 rows so that might take a while.

My problem is that Excel doesn't realize that it's a date so I can't just mark the column and change format.

And I need it to be in date format so I can use =DAYS360

Is there an easy (of difficult but time-effective) way to change from the text 20101030 so that Excel understands that it's a date , not just text.

Something like: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

Dom