An Excel autocorrect feature that has driven geneticists crazy for years has finally been rectified.
Even if you're not a scientist studying genentics,Kurt Meinicke you've surely come across this issue. When entering data into Microsoft Excel, the spreadsheet will sometimes interpret alphanumeric formulas as dates and automatically format it as such. Genes symbols often have names that are incorrectly assumed to be dates, such as SEPT2 or MARCH1, which have created a headache for scientists just trying to input their data. So much so that a 2016 study found one-fifth of research papers using data compiled in Excel to be incorrect or corrupted. It got to the point that scientists actually began renaming genes to avoid the infuriating auto-conversion.
SEE ALSO: Microsoft AI can take meetings for you nowNow, Microsoft finally has a fix. In an announcement last week, the Microsoft 365 team released a setting that enables Excels users to change the overly helpful default behavior.
To turn off this setting in Excel, go to File > Options > Data, then scroll down to Automatic Data Conversion. Then uncheck the setting that says "Enable all default data conversions below when entering, pasting, or loading text into Excel." There are also sub-settings to disable the removal of leading zeros, truncating numerical digits to a certain format, and the auto conversion of numerical data around the letter "E," as well as the aforementioned auto-conversion of continuous letters and numbers into a date.
Finallyyyyy. Credit: Microsoft Additionally, there's an option to notify the user of any auto-conversions when importing a .csv file into Excel. However, Microsoft said in the announcement, there are a few exceptions. Excel saves the data as text, meaning it might not work for mathematical calculations. Also, there's a known issue that doesn't support the disabling of auto-conversions when running macros.
That said, it's a long overdue setting that's sure to make geneticists happy and hopefully prevent future errors and naming predicaments.
Topics Apps & Software Microsoft
Sri Lanka vs. Australia 2025 livestream: Watch 1st ODI for free
Manchester City's UCL final win was certainly a game the internet watched
Wes Anderson isn't crazy about your Wes Anderson aesthetic memes
Donald Trump has been indicted again, and he's mad about it
Miami Heat vs. Brooklyn Nets 2025 livestream: Watch NBA online
Selections from Leonard Cohen’s Notebooks
What does queer mean?
15+ Cyber Monday 2023 Chromebook deals at Best Buy
Amazon CEO tries to sell kids on working on the moon
A History of the Novel in Two Hundred Essays
Meta says some AGI systems are too risky to release
Match Group removes 44 spam accounts every minute
Amazon's Cyber Monday laptop deals are shockingly great
Match Group removes 44 spam accounts every minute
Meta says some AGI systems are too risky to release
A Reckoning is Different Than a Tell
Walmart Cyber Monday laptop deals: Lenovo Flex 5i for $299
Alaska Airlines Cyber Monday sale: One
Dallas Mavericks vs. Boston Celtics 2025 livestream: Watch NBA online
Cyber Monday Nintendo Switch deals 2023: The 'Mario Kart 8 Deluxe' bundle is back
Video shows incredible rescue off capsized boat following Hurricane MariaAmazon's 'Hunger Games' for a new HQ puts cities in a race to the bottomMarilyn Manson interview goes viral and this journalist deserves a gold medalFor the mainland U.S., Hurricane Maria's path is now a waiting gameFrida the Mexican Labrador retriever helps rescue people during natural disastersWatch an army of robots efficiently sorting hundreds of thousands of packagesAttention, human monsters: You can now purchase a Border Patrol Agent costume for HalloweenHurricane Maria slams Puerto Rico, Caribbean — here's how to helpJK Rowling, Facebook, and Apple among those donating to Mexican earthquake reliefiOS 11 makes sexting on Snapchat riskier than ever. That's why you need the next update.Attention, human monsters: You can now purchase a Border Patrol Agent costume for HalloweenJimmy Kimmel tears apart his critics on health care billBig fat Stratolaunch plane tests all six of its enginesNow there's a Porsche superyacht because regular yachts are for suckersApple TV 4K review: A solid update that costs too muchToddler can't help but tear up while watching a dinosaur fall downJK Rowling, Facebook, and Apple among those donating to Mexican earthquake relief'The Good Place': Why you should watchAmazon customers can now return things for free at Kohl's or Whole FoodsMarilyn Manson interview goes viral and this journalist deserves a gold medal The Workers Blunt Force Israel’s Permit Regime Privileges of Misery The Miseducation of Kara Swisher Boy Afraid Into the Meat Grinder Sick and Tired Queers Without Money Parting Waters UN member states have agreed to a treaty protecting the high seas Lying Eyes Night Vision Toward an Intellectual History of Genocide in Gaza Low, Dishonest Days The Fear and the Fix Two Shores, One Sea The Republican Heels Take It to the Spank Bank Are We Undone?
3.2418s , 10137.15625 kb
Copyright © 2025 Powered by 【Kurt Meinicke】,Pursuit Information Network