Microsoft Excel gets better at handling scientific data | Technology News – Life Changer

Microsoft Excel gets better at handling scientific data | Technology News

[ad_1]

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.



[ad_2]

Source link

Loading

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

  1. When we suspect that our wife or husband has betrayed the marriage, but there is no direct evidence, or we want to worry about the safety of our children, monitoring their mobile phones is also a good solution, usually allowing you to obtain more important information.

  2. Wow, awesome weblog format! How long have you ever been running a blog for?
    you make running a blog look easy. The full glance of your web site is fantastic, as smartly as the content!

    You can see similar here e-commerce

Leave a Reply

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