Scientists rename genes because Microsoft Excel reads them as dates:
Microsoft Excel’s automatic formatting is normally helpful for finishing spreadsheets quickly, but it’s proving to be an agent of chaos for geneticists. The Verge has learned that the HUGO Gene Nomenclature Committee has issued guidelines for naming human genes to prevent Excel’s automatic date formatting from altering data. MARCH1 (Membrane Associated Ring-CH-Type Finger 1), for example, should now be labeled MARCHF1 to stop Excel from changing it to 1-Mar.
The names of 27 genes have been changed in the past year to avoid Excel-related errors, HGNC coordinator Elspeth Bruford said. This isn’t a rare error, either, as Excel had affected about a fifth of genetics-related papers examined in a 2016 study.
Journal Reference:
Mark Ziemann, Yotam Eren, Assam El-Osta. Gene name errors are widespread in the scientific literature [open], Genome Biology (DOI: 10.1186/s13059-016-1044-7)
(Score: 0) by Anonymous Coward on Saturday August 08 2020, @06:33PM
Look at all the idiots here saying the auto feature shouldn't on by default.
That auto thing works fine for 90% of the cases for 80% of the population, who we all should know are stupid people that wouldn't be able to remember how to set a column to a date type even to save their life.
The problem here is a corner/fringe case where the auto thing is not working fine for people who are supposedly significantly smarter than the stupid people. Y'know geneticists aka scientists?
Maybe these smart people should use their supposedly above average brains to learn how to use Excel properly?