Microsoft Excel gets better at handling scientific data | Technology News


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.

Most Read

1
Leo box office collection Day 3 early reports: Vijay’s film bounces back, records 10% spike in earnings
2
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.

New data conversion options introduced on Excel (Image credit: Microsoft)

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.





Source link

27 thoughts on “Microsoft Excel gets better at handling scientific data | Technology News

Leave a Reply

Your email address will not be published. Required fields are marked *