Microsoft Excel's Data Conversion Issues Resolved with Latest Updates
Originally Published 2 years ago — by The Verge
Microsoft has released an update for Excel on Windows and macOS to fix a feature that was causing scientific data to be incorrectly reformatted. The feature, which automatically converted alphanumeric symbols into dates, had been causing problems for scientists trying to input gene names. The update includes a checkbox that allows users to toggle the conversion, building on previous settings that warned users before making automatic conversions. However, there are some caveats, such as the data being saved as text and potential issues with disabling conversions when running macros.