Convert general text to date

I have a column of values with general formating like so:

20050309
20050322
20050401

Where the first 4 digits are the year, next 2 the month and the last 2 digits the day. Can someone tell me an easy way to convert these general values to a valid date format?

Thanks in advance

In a blank column you would need to use this fourmula
=DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))
You can then copy and special paste values - if you wish to

or

you would need a macro to change the value of each date cell

Excellent....thank you very much.