Microsoft Excel has made significant improvements in handling scientific data. Microsoft has introduced a new feature to Excel, making it easier for scientists to use a variety of alphanumeric and numerical symbols.
This update will be available to both Windows and Mac users. With this update, Excel will no longer automatically convert gene numbers and other scientific data into dates, allowing scientists to use the data accurately within the Excel application.
Previously, this issue forced scientists to rename genes, necessitating further adjustments at the time of publication, potentially leading to data corruption. The new update builds on the automatic data conversion feature introduced by Microsoft last year, providing Excel with more control over the automatic data conversion process when disabling this feature.
These features are enabled by default, and users should disable them to prevent Excel from automatically converting data. There is also an option to prevent automatic data conversion when loading a .csv file or similar in Excel.
It should be noted that these features will not work while executing a macro function or when reading a macro input to perform simple repetitive actions.