Microsoft adds new capability to Excel to handle scientific data better
By MYBRANDBOOK
Microsoft has added a new capability to Excel, which makes it easy for scientists to use various alphanumeric symbols. 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.
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 automatic data conversion feature, which Microsoft introduced last year, where, when disabled, Excel offers more control over automatic data conversion.
The new capability, known as "auto data conversion options," provides users with more control over how Excel interprets and displays scientific data. With this update, Excel will no longer automatically convert gene names and other alphanumeric data into dates. Instead, users can choose to disable automatic data conversion altogether or selectively enable it for specific data types.
This improvement is particularly beneficial for scientists who frequently work with gene names and other alphanumeric identifiers. Previously, Excel's automatic data conversion could lead to data corruption and inaccurate results, as gene names would be misinterpreted as dates. With the new auto data conversion options, scientists can maintain the integrity of their data and avoid unintended conversions.
Legal Battle Over IT Act Intensifies Amid Musk’s India Plans
The outcome of the legal dispute between X Corp and the Indian government c...
Wipro inks 10-year deal with Phoenix Group's ReAssure UK worth
The agreement, executed through Wipro and its 100% subsidiary,...
Centre announces that DPDP Rules nearing Finalisation by April
The government seeks to refine the rules for robust data protection, ensuri...
Home Ministry cracks down on PoS agents in digital arrest scam
Digital arrest scams are a growing cybercrime where victims are coerced or ...
ICONS OF INDIA : S KRISHNAN
S Krishnan as the secretary for the electronics and information techno...
Icons Of India : Dr. Arvind Gupta
Arvind Gupta is the Head and Co-Founder of the Digital India Foundatio...
Icons Of India : Bhavish Aggarwal
Indian entrepreneur Bhavish Aggarwal is the CEO of Ola, India’s larg...
GSTN - Goods and Services Tax Network
GSTN provides shared IT infrastructure and service to both central and...
C-DOT - Center of Development of Telematics
India’s premier research and development center focused on telecommu...
HPCL - Hindustan Petroleum Corporation Ltd.
HPCL is an integrated oil and gas company involved in refining, market...
Indian Tech Talent Excelling The Tech World - NIKESH ARORA, Chairman CEO - Palo Alto Networks
Nikesh Arora, the Chairman and CEO of Palo Alto Networks, is steering ...
Indian Tech Talent Excelling The Tech World - Sanjay Mehrotra, CEO- Micron Technology
Sanjay Mehrotra, the President and CEO of Micron Technology, is at the...
Indian Tech Talent Excelling The Tech World - Aman Bhutani, CEO, GoDaddy
Aman Bhutani, the self-taught techie and CEO of GoDaddy, oversees a co...