Hello all, I have recently had this similar issue in importing an excel csv file. However, now I have removed the previous file from the global environment using rm() function, went back into the excel csv file and converted all cells to either 'date' or 'number' format.... no commas to be found anywhere.
No issues there, it looks good.. HOWEVER, upon entering the following code to convert to a time series:
I'm now getting another unintended transformation in all 4 columns.
I have noticed that when I changed the excel csv file to 'number' format, saved, closed, then re-opened the file, excel seems to want to change cells back to 'general' format. Is this an issue? There are no commas anywhere that I can find!
Any suggestions for why/how this transformation keeps happening?
Any/all help = greatly appreciated.