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