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.55 votes
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]
- Don't see your idea?