Advertisement

One in five genetics papers contains errors thanks to Microsoft Excel

One in five genetics papers contains errors thanks to Microsoft Excel
PLOS ONE PHYLOGENY/Flickr (CC BY 2.0)

Autoformatting in Microsoft Excel has caused many a headache—but now, a new study shows that one in five genetics papers in top scientific journals contains errors from the program, The Washington Post reports. The errors often arose when gene names in a spreadsheet were automatically changed to calendar dates or numerical values. For example, one gene called Septin-2 is commonly shortened to SEPT2, but is changed to 2-SEP and stored as the date 2 September 2016 by Excel. The researchers, who published their analysis in Genome Biology, say the issue can be fixed by formatting Excel columns as text and remaining vigilant—or switching to Google Sheets, where gene names are stored exactly as they're entered.

Support nonprofit science journalism

Help News from Science publish trustworthy, high-impact stories about research and the people who shape it. Please make a tax-deductible gift today.

Donate

Not Now

Thank you for reading News fromScience.

You have reached your limit of 3 free news stories in the past 30 days.

To gain unlimited access to News fromScience, pleaseLog inor subscribe to News from Science.

AAAS Members canLog infor unlimited access.

$2.99/Month$25/YearFrequently Asked Questions