My dates get scrambled.

I have a .csv file with dates in the first column in dd/mm/yy format.

If I open it in Excel the values are correctly entered as date values.

If I open it in a VB macro the dates are mangled.  So 20/03/2024 appears as text whilst 03/05/2024 is converted to a date value and displays as 05/03/2024 which is incorrect.  The system date format is dd/yy/mm like the file data.

How can I get all the dates converted to date values with day and month in the correct order?  Is it possible to use the input wizard in the VB macro?

Any help would be most appreciated.

​My dates get scrambled.I have a .csv file with dates in the first column in dd/mm/yy format.If I open it in Excel the values are correctly entered as date values.If I open it in a VB macro the dates are mangled.  So 20/03/2024 appears as text whilst 03/05/2024 is converted to a date value and displays as 05/03/2024 which is incorrect.  The system date format is dd/yy/mm like the file data.How can I get all the dates converted to date values with day and month in the correct order?  Is it possible to use the input wizard in the VB macro?Any help would be most appreciated.  Read More

​