Re: Don't use Excel for CSV files! (Score 1)

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.