{"id":256333,"date":"2023-10-24T08:33:58","date_gmt":"2023-10-24T12:33:58","guid":{"rendered":"https:\/\/sftarticles.wpenginepowered.com\/en\/?p=256333"},"modified":"2025-07-01T17:52:53","modified_gmt":"2025-07-02T00:52:53","slug":"microsoft-ends-excels-science-data-nightmare","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/en\/microsoft-ends-excels-science-data-nightmare\/","title":{"rendered":"Microsoft ends Excel’s science data nightmare"},"content":{"rendered":"\n

In 2020, researchers opted to modify the alphanumeric symbols representing genes to circumvent an Excel feature that mistakenly recognized their names as dates, automatically reformatting them. Recently, an Excel<\/a> team member announced<\/a> that an update is being introduced for both Windows and macOS to address this issue.<\/p>\n\n\n\n

Excel’s auto-conversion feature aims to simplify the entry of common data types, like numbers and dates. However, for scientists using shorthand for clarity, this feature could inadvertently distort published, peer-reviewed data, as highlighted in a 2016 study.<\/p>\n\n\n\n

Microsoft elaborated on this update in a recent blog post<\/a>, introducing a checkbox titled \u201cConvert continuous letters and numbers to a date.\u201d<\/p>\n\n\n

\r\n
\r\n
\r\n
\r\n \"Microsoft\r\n <\/div>\r\n
\r\n Microsoft Excel<\/span>\r\n DOWNLOAD<\/a>\r\n <\/div>\r\n
\r\n <\/path><\/path><\/text><\/svg>\r\n <\/div>\r\n <\/div>\r\n
\r\n <\/span>\r\n <\/div>\r\n
\r\n \r\n <\/div>\r\n <\/a>\r\n <\/div>\r\n<\/div>\n\n\n\n

Its function is self-explanatory. This enhancement complements the Automatic Data Conversions settings introduced the previous year. These settings alert users before Excel’s auto-conversion kicks in, allowing them to open their files without the automatic conversion, ensuring data integrity.<\/p>\n\n\n\n

How does it work?<\/h2>\n\n\n\n

Microsoft has taken steps to alleviate user frustrations stemming from Excel’s tendency to auto-convert data into specific formats. Users now have the flexibility to modify Excel’s default settings and deactivate certain automatic data conversions as required.<\/p>\n\n\n\n

To implement these changes, navigate to File<\/strong> > Options <\/strong>> Data <\/strong>> Automatic Data Conversion<\/strong>. From there, you can select which conversion(s) you wish to deactivate.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Additionally, Microsoft has provided some useful pointers:<\/p>\n\n\n\n