News for hackers. Stuff that matters.
Re:Excel warriors who save governments and companies from sp... by n4r9 on Saturday October 17, 2020 @08:00PM (#24814477)
Ok, it might try to deduce the data type, but you can set it in the import options that appear when you open a CSV file. Excel will automatically convert a string like "2-4" to "02-Feb" upon opening a CSV file. No import options appear when you open the file. If you then save the file it then uses that new string. As far as I can tell there's no way to stop it doing this.

There are no comments on this comment yet.