Connect with us

News Report

Scientists rename genes because Microsoft Excel reads them as dates

WebSite Design  404-590-1763

Tech News

Scientists rename genes because Microsoft Excel reads them as dates

Guidelines for human gene nomenclature: Symbols that affect data handling and retrieval. For example, all symbols that autoconverted to dates in Microsoft Excel have been changed (for example, SEPT1 is now SEPTIN1; MARCH1 is now MARCHF1); tRNA synthetase symbols that were also common words have been changed (for example, WARS is now WARS1; CARS is…

Scientists rename genes because Microsoft Excel reads them as dates

Guidelines for human gene nomenclature:

Symbols that affect data handling and retrieval. For example, all symbols that autoconverted to dates in Microsoft Excel have been changed (for example, SEPT1 is now SEPTIN1; MARCH1 is now MARCHF1); tRNA synthetase symbols that were also common words have been changed (for example, WARS is now WARS1; CARS is now CARS1).

There will still be a library of discarded names and symbols to help reduce confusion going forward.

The scientific community has changed gene names before, but usually to minimize false positives in search results or to be sensitive to the concerns of patients. Now, it’s directly in response to software design — technology is getting in the way of research rather than speeding it up.

We’ve asked Microsoft for comment on the issue. However, we wouldn’t count on an Excel patch solving the issue. Buford noted to The Verge that genetic data represents “quite a limited use case” for Excel, and that an option to disable the date formatting would only help a tiny number of users. Still, this is a reminder that automatic formatting can easily go haywire, and that you shouldn’t take it for granted.

In this article:

genes, DNA, Genetics, science, EXCEL, RNA, Spreadsheet, Microsoft, spreadsheets, news, gear

All products recommended by Engadget are selected by our editorial team, independent of our parent company. Some of our stories include affiliate links. If you buy something through one of these links, we may earn an affiliate commission.

Real Life. Real News. Real Voices

Help us tell more of the stories that matter

Become a founding member

Comment


Comments

Share

1228
Shares

Subscribe to the newsletter news

We hate SPAM and promise to keep your email address safe

300*250

Popular Articles

Latest News

To Top