Date time stamp to date conversion

Hi, I am hoping someone can help me with my problem.
I have an extract from DB2 table and the format is November 16, 2012 12:00:00 AM EST, I am trying to convert it to 11/16/2012. I have tried changing to different date formats but no luck. I am trying to incorporate the date conversion functionality, which will be part of other simple code.

I have attached a sample file, any help or responses would be greatly appreciated.

Thanks
Nitin

They aren't 'real' date values so formatting won't make a difference.

Try this.

Sub condt()
Dim rng As Range
Dim cl As Range

    Set rng = Intersect(ActiveCell.EntireColumn, ActiveSheet.UsedRange)
    Set rng = rng.Offset(1, 0).Resize(rng.Rows.Count - 1)
    For Each cl In rng
        If cl.Value <> "" Then
            cl = DateValue(Left(cl, Len(cl) - 15))
        End If
    Next cl

End Sub