I have a macro that I created to format some data. This data utilized the dd/mm/yyyy hh:mm format. I tried just formatting these columns to the mm/dd/yyyy hh:mm format but that doesn't work. So my work around was that I did a text to columns split separating the date and time fields. This works but I have noticed that many times the various time columns will display an incorrect formatting i.e., 1.39E-02 in one or several cells, but not all of them. I can clean this up and reformat these columns but feel that defeats the purpose of creating and running the macro. I have attached two files the first is once called MIDataclean up, this is the one with my script in it. The second is called waslog MI Reports, this contains my data that I am trying to clean up.
First off, I apologize for the uncleanliness of my script as I am still learning but any help or feedback you can provide to help run this script more efficiently that would help.