3 ms·
"But if you reopen that exact same file, Excel will still misinterpret the number." No, you can set the import to treat it as a text field. It is really easy
by protomyth 11y ago
"But if you reopen that exact same file, Excel will still misinterpret the number."
No, you can set the import to treat it as a text field. It is really easy and this should not be a problem. The import can define field by field what it should be treated as (most often used with dates).
- yen223 11y agoThe problem here is that, like the folks mentioned in the article, I wasn't the one opening the file on Excel. I'm generating a CSV file from a webapp to be sent to clients for processing. They would double-click the file, and see those mangled fields. The real issue here is that Excel doesn't respect quotes on a CSV file for some inane reason. That is a bug on Microsoft's end.