Provide way to avoid automagical field value reformatting when opening CSV files
Theis is related to the leading zeroes one, but it is at least as bothersome that it tries to format as an excel data anything that looks like a date -- including values that are not dates. And the date formatting means you can't use Excel to open a CSV with dates, edit it, and re-save it without completely changing the way dates are formatted.
Thanks for all the votes and comments for this suggestion. We are considering improvements to how Excel deals with reformatting (or not) as data is imported and entered from CSV and other sources. Your comments are very helpful.
Steve K [MS Excel]
Maybe adopt the way how google spreadsheets is dealing with csv files. They simply ask, if you want to format numbers, or leave them as they are. Can't tell you how annoying it is, when e.g. amounts, get formated to date with no way of returning to the original number again. I switched to google spreadsheets for importing .csv files and download them afterwards, cause it works and doesn't destroy the data.
This would be a huge improvement. Excel is used often to analyze phone system call detail records. Phone numbers and dialed digits often are very long which are converted to scientific notation or begin with a leading + or leading 0 (which are dropped).
Joe Park commented
Additionally, please include an option to prevent autoformatting of numerical string values in CSV files to scientific notation. In practice this behavior appears to automatically drop numbers beyond the 6th significant digit upon saving and has wreaked havoc on the work of many unsuspecting users in our office.