【????? ????? ?????? ??????? ????????】Microsoft Excel finally lets you disable aggressive auto

An Excel autocorrect feature that has driven geneticists crazy for years has finally been rectified.

Even if you're not a scientist studying genentics,????? ????? ?????? ??????? ???????? 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 now

Now, 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.

Mashable Light Speed Want more out-of-this world tech, space and science stories? Sign up for Mashable's weekly Light Speed newsletter. By clicking Sign Me Up, you confirm you are 16+ and agree to our Terms of Use and Privacy Policy. Thanks for signing up!

---

You May Also Like

---

---

How to turn off Automatic Data Conversion

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

• recreation
• knowledge
• relaxation
• synthesize
• explore
• focus
• fashion
• hotspot

• Banksters Minting Scrolls on Magic Eden
• Sam Bankman
• Wordle today: Here's the answer, hints for January 5
• How to make your own Spotify time capsule
• HUMANS is welcoming aspiring builders in the Web3 Builders Bootcamp
• Wordle today: Here's the answer, hints for January 6
• 'M3GAN' ending explainer: How that final shot sets up a sequel
• SAG nominations 2023: Full list
• A Journey Through the Life of George Takei
• Where to see Earth's dying glaciers before they disappear

• Robinhood to reopen GameStop buying after $1 billion raise
• Google Maps adds EV route planning feature that’ll be familiar to Tesla drivers
• Netflix's 'Malcolm and Marie' lands like a pay
• 'Framing Britney Spears' will make you rethink Britney
• Apple Car will initially be driverless, report says
• Facebook claims it won't recommend political groups globally
• Hedge fund Melvin Capital is down $4.5 billion after epic squeeze by Reddit traders, report says
• Twitter thinks it knows why Jeff Bezos stepped down as Amazon CEO
• You'll soon be able to unlock your iPhone while wearing a face mask
• 'Bonding' Season 2 is a good crash course in BDSM for curious couples

• INTO THE NEXT STAGE: Catching Up
• 'Quordle' today: See each 'Quordle' answer and hints for January 11
• 'Quordle' today: See each 'Quordle' answer and hints for January 6
• Amazon's 'Hey Disney' voice assistant is coming to your home Echo devices
• ETH Tallinn: Igniting the Future of Ethereum in the Baltics
• CES 2023: BMW brings another colour
• CES 2023: Ring drops pre
• Wordle today: Here's the answer, hints for January 9
• ‘Allegiance’ Returning to the Big Screen
• Meta Quest 1 will no longer get feature updates

• INTO THE NEXT STAGE: Genie Nakano Goes Beyond the Lines with Coloring Book for Grownups
• Wordle today: Here's the answer, hints for January 11
• Virgin Orbit's historic UK launch fails due to 'anomaly'
• CES 2023: LG M3 is a port
• LTHS Seeks Entries for 2017 Short Story Contest
• Wordle today: Here's the answer, hints for January 8
• 'Quordle' today: See each 'Quordle' answer and hints for January 11
• Amazon announces plans to lay off over 18,000 employees
• BeInCrypto Partners Restaking and Emerging Markets Online Summit
• Tesla cars have gotten a lot cheaper overnight