I use.csv file often, without issues. HOWEVER, I NEVER open a.csv file with Excel.
Rather I IMPORT the data into Excel via Data > Get External Data... I control the data type of each column in this way, and columns that I do not want converted, I assign as TEXT, and columns I want converted as dates, I assign as MDY, DMY, YMD as required.
Slashdot Mirror
I use .csv file often, without issues. HOWEVER, I NEVER open a .csv file with Excel.
Rather I IMPORT the data into Excel via Data > Get External Data ... I control the data type of each column in this way, and columns that I do not want converted, I assign as TEXT, and columns I want converted as dates, I assign as MDY, DMY, YMD as required.