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)
Thanks in advancePlease Login or Register to view this content.
Bookmarks