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 stri

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.