2 ms·
If an excel spreadsheet is setup properly, this conversion doesn't happen. If the cells are designated as "text", then conversion doesn't happen. This is defin
by Tagbert 5y ago
If an excel spreadsheet is setup properly, this conversion doesn't happen. If the cells are designated as "text", then conversion doesn't happen.
This is definitely a problem if you are just opening a raw CSV file and editing it as the default cell type does allow autoconversion.
- djbebs 5y agoExcept from personal experience I can tell you that even when you go out of your way to set the correct data types, if you try to copy paste any data into those cells excel will ignore everything you set and try to automatically change the data types. If you know how to get it to never do that sort of thing, please let me know, because this is causing major issues in production software...