Earlier quoted context omitted.
> CSV import in Excel sucks I'm going through a project at the moment where all the data is held in spreadsheets, and every time anyone opens them Excel fucks the numbers to be "scientific notation" despite there being space to display the full number and no way to disable this anti-feature. The amount of times I've had to restore the spreadsheet from a backed up CSV because of data loss is frustrating. I wish I coul…
This is just a formatting/display issue. Excel isn't rounding the number internally. It sounds like the problem in this case is that you don't know how to use basic Excel features.
In 2020, scientists decided just to rework the alphanumeric symbols they used to represent genes rather than try to deal with an Excel feature that was interpreting their names as dates and (un)helpfully reformatting them automatically. Yesterday, a member of the Excel team posted that the company is rolling out an update on Windows and macOS to fix that.
https://www.theverge.com/2023/10/21/23926585/microsoft-excel...
Also it drops leading zeros which is annoying when a column is zip codes and it should be imported as string and not number
I agree excel gives ways around these and maybe that's considered basic knowledge but it definitely has poor data-mangling defaults