Macro mess with the date formatting

I'm working on my team metrics. I receive a bunch of incidents with the corresponding dates and times in the US format (mm/dd/yyyy HH:MM:SS)
For some reason, when I move the data from the cvs file to the xls I work, it modify all dates over the 13th.
I have been working this manually to get mm/dd/yyyy. But when I tried to move the manual steps to a macro it mess the formatting again

Please Login or Register  to view this content.

Basically the script do the same I do manually:
- Copy the dates to an aux column
- Using Text to columns, remove the time
- Change the format to text
- Use the formula to get the dates
- Clean the format from the destination
- Change the format to get mm/dd/yyyy
- Copy the data
- Remove the aux columns


I don't know VBA language to script the macro, so I used the auto recording from excel.

I have attached a test spreadsheet I have using.
test formats.xlsx

Any help will be appreciate

That won't work, because not all the dates are in dd/mm/yyyy.
Only the dates after the 13th are in that format.

I know the macro is using the column B. I attached a test spreadsheet to see the different dates I'm using.