284 votes53 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
Thanks for the suggestion Jessica. We’ve got a few other suggestions on the site that are similar with scientific notation, etc. We’ll take a look at this area, and pay special attention to any cases that get a lot of votes. So please keep the votes coming to help us do a good job at prioritizing asks like this!
John [MS XL]Anonymous commented
This is a very widespread problem in the scientific community. If you need proof, here is a link to a recent paper: that has been viewed over 56000 times.
"Gene name errors are widespread in the scientific literature"
"...The spreadsheet software Microsoft Excel, when used with default settings, is known to convert gene names to dates and floating-point numbers. A programmatic scan of leading genomics journals reveals that approximately one-fifth of papers with supplementary Excel gene lists contain erroneous gene name conversions."
If this many scientists have problems with Excel, this is not a trivial problem.
The paper also points out that Google Sheets does not suffer from this problem.
MengshuAnonymous supported this idea ·