I have a .csv file that is created via batch file with date columns.
I have to edit one of the date columns with another date format.
I can get the column to look how I want it to look, but it is in TEXT format (copied from notepad).
I want to insert this data in to the spreadsheet without causing the whole .csv file to lose its formatting.
When i insert this data, all of the other dates in other columns disappear and even if i format those columns with DATE, they are automically changed to the year 1900.
I have tried to import the data while retaining the comma but it still does not want to have this column that I am trying to insert.
Any help would be greatly appreciated.
I am using office 2013.