I have a .csv which I'm trying to open in MS Excel. If I open the CSV in a text editor, one of the dates looks like this:
09/03/19 but in Excel it shows like this:
i.e., it's broken in both the table view, and the formula editor text thingy. To be clear, by "broken" I mean that this is the incorrect date, not that I dislike how it's formatted.
The correct date in this example is
Sept 3, 2019. I don't care how it's formatted (that can be changed), I just need Excel to interpret it correctly or not format it at all.
If I change the formatting to "General", it converts my date into a
non-sense number internal representation:
Same for "Text".
How do I get Excel to stop reinterpreting my data?
My Excel version, if needed:
(copy-paste doesn't work)