3 ms·
My two favorite problems with Excel automatic type conversions: Zip codes that lose leading zeros. Gene names that get converted to dates. The names of some
by mark-r 5y ago
My two favorite problems with Excel automatic type conversions:
Zip codes that lose leading zeros.
Gene names that get converted to dates. The names of some genes were recently changed because too many databases were being corrupted by researchers using Excel to read CSV files: https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates https://www.theverge.com/2020/8/6/21355674/human-genes-renam...