Hello and thanks for your time reading this.
I'm exporting a csv file from a membership database with the attendance of members. With a macro i open the file and copy the contend to excel.
With the macro the column for the date has *randomly* wrong formats.
Example the date in column B:
Aasia Tallah 19-03-2009 19:33
Aasia Tallah 17/03/09 7:49 pm
Aasia Tallah 15/03/09 7:53 pm
Aasia Tallah 14/03/09 6:34 pm
Aasia Tallah 03-12-2009 20:05
Aasia Tallah 03-11-2009 19:56
Aasia Tallah 03-10-2009 19:54
I try to change the format of the column, but that does not work.
Rows 2,3 and 4 seem to be text but they are not. If i access the edit bar for example the 17th of march and store without changing anything, it changes to the format of the first row. That is how i want it.
If i copy the column by hand, every thing is fine.
All of the following i tryed:
- format date column of the csv before copying... failed
- copy special with only pasting values... failed
- preformat the column i paste the date to... failed
- delete the sheet i paste to and create a new one... failed
- copy the macro to a new workbook... failed
Any suggestions?
I could run a macro on all of the over 2500 cells with dates, copy and paste in the same cell... that would work i guess, but i'd rather like to know why this happens.
Thanks for any input on this subject, Google search did not help :-)
Bookmarks