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.
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