Converting Strings To Dates

converting text strings to dates.

The dates I have imported into a spreadsheet are of the format:

11.05.08

I use code to convert it to this format

11/5/08

But with some of the dates, I get

11/5/2008 whereas with others, I get

11/5/08

However, if I recorded a macro the date format appears as

11/5/2008 for all the dates.

But the code is excatly the same, if I

see below:

My

For Each celld In Range([e1], [a1].End(xlToRight))

If celld.Value Like "*DATE" Then
celld.EntireColumn.Select

On Error Resume Next

Also, how do you convert strings to dates using VBA?

I thought DATEVALUE performed this function but keep getting errors when i try using it.