VBA solution to convert mixed UK/US date formats

Hi All

I have a macro to import data from a .csv file that contains dates in DD/MM/YYYY format - which is the format I need.

At some point in the process, some of the dates are converted to MM/DD/YYYY.

I am using Excel 2016 and I think I have a solution using "Text to Columns" but when I record it as a macro, the step that involves formatting the column data as MDY does not appear to get recorded.

How would I write this into the code? (Assuming this is the right way to do it)

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

Thanks in advance