I'm running a macro to import a number of CSV files (20 to be exact) into one ssheet and then another series of macros to perform the data clean up on each of the worksheets.
The data, extracts from an e-mail database, contains a Date & Time value in amongst the other data in the string.
The issue is that when the data is separated out in using the recorded macro the dates are not being preserved and in some instances it appears that the Month and Day are being transposed!
Here's the macro that is doing the conversion....
A straight text to columns and changing the column value on a single sheet preserves the date no problem, it seems to be the macro thats messing this up!
The date values are critical in what i'm doing here and its really bugging me that excel is gubbering them around like this, anyone got any ideas how to fix this?