VBA solution to convert mixed UK/US date formats

Thanks, below is more of the macro I use to import the data:

ChDir "C:\Export"
    Workbooks.Open Filename:="C:\Export\DEBTP.csv"
    Range("A1:L150000").Select
    Selection.Copy
    Windows(ThisWorkbook.Name).Activate
    Sheets("DEBTP").Visible = True
    Sheets("DEBTP").Select
    Range("A2").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
    Application.CommandBars("Office Clipboard").Visible = False
    Windows("DEBTP.csv").Activate
    ActiveWindow.Close
    Windows(ThisWorkbook.Name).Activate
    Sheets("DEBTP").Select
    Columns("C:C").Select
    Selection.TextToColumns Destination:=Range("C1"), DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
        Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
        :=Array(1, 3), TrailingMinusNumbers:=True
    Range("A1").Select