Dear Excel Experts,
Currently, I'm using a vba script to copy content in every sheet1 in csv file into the new worksheet tab next to Sheet1 in master workbook. It supposed to compile all csv file content into one master workbook.
However, I notice that those dates format will automatically...
in csv file I have column, where are date's with diffrent format as below:
7/03/2013 8:30:00 PM
I want to set up the same format for all date's.
I`m doing something like:
LastRow = WS.Cells(WS.Rows.Count, "A").End(xlUp).Row
I am having a little trouble using a macro when copying some dates in that it mixes up UK and US date formats.
I have a .csv file in which in one column there are some date values in the UK format "dd/mm/yyyy", such as 10/08/2010 for 10th August 2010. Now, when I open this .csv file, and...