Microsoft has added a new capability to Excel, which makes it easy for scientists to use various alphanumeric symbols and the update is being rolled out to Windows and Mac users. With this update, Excel no longer automatically converts gene numbers and other scientific data as dates and allows scientists to use proper data within the Excel app.
This shortcoming made scientists rename genes, which again had to be reworked at the time of publishing, which would otherwise ruin the data. The new update is based on the feature of automatic data conversion, which Microsoft introduced last year, where, when disabled, Excel will notify users about automatic data conversion.
Leo box office collection Day 3 early reports: Vijay’s film bounces back, records 10% spike in earnings
AR Rahman ‘totally changed’ after embracing new faith, changing name from Dilip Kumar: Sivamani
These features are enabled by default, and users have to disable these to prevent Excel from automatic data conversion. There is also an option to prevent automatic data conversion while loading a .csv or similar file on Excel. Do note that these features won’t work during a macro execution or while reading a macro entry to perform simple repetitive actions.
How to disable automatic data conversion on Microsoft Excel?
To disable automatic data conversion on Microsoft Excel, go to File > Options > Data > Automatic Data Conversion and disable the respective options.
To use these new features, one has to update Excel to version Version 2309 (Build 16808.10000) or later on Windows and Version 16.77 (Build 23091003) or later on Mac.