What you need to know
- Microsoft is shipping a new update to Excel for Windows and Mac users.
- The update addresses an annoying feature that affected data enthusiasts and scientists.
- Users will now have the option to disable automatic data conversions that convert their alphanumeric symbols into dates.
- The feature will not work during macro execution.
Microsoft is finally fixing an annoying Excel feature that data enthusiasts and scientists will appreciate. You might recall the automatic data conversion feature, which shipped to the platform last year for Windows and Mac users. It's essentially designed to help users control how and whether the data entered into the spreadsheet is automatically converted to specific formats.
While it's a resourceful feature, it doesn't play nicely with alphanumeric symbols, as it converts gene numbers and other scientific data into dates. However, this will no longer be the case as Microsoft is rolling out a new update for Windows and Mac users to address this issue.
Consequently, users will now be able to establish more control over the automatic conversion of their data. Users will also receive a notification from Excel highlighting the automatic conversion before it takes place. This will give the user ample time to decide if this is a change they'd like to implement on the file.
Users will need to navigate through the settings to disable these features since they are enabled by default so as to ensure that their data is not affected by the feature. Users can also prevent automatic data conversion while loading a .csv or similar file on the platform. However, the features won't work during macro execution.
How to disable automatic data conversion on Microsoft Excel
As highlighted above, automatic data conversion settings are enabled by default. You'll need to navigate through the settings to disable them, as outlined below:
- Launch Microsoft Excel on your device and click on Files.
- Next, select Options and click on Data.
- Finally, select Automatic Data Conversion and check off the boxes for the settings you'd like to disable.
Microsoft 365 Personal | From $70/year
Microsoft 365 Personal comes with the Office suite and 1TB of OneDrive storage. It allows you to work from several devices, including Windows, macOS, iOS, and Android. It also includes a long list of other apps and services, such as Editor, Microsoft Forms, and Microsoft Teams.
Get the Windows Central Newsletter
All the latest news, reviews, and guides for Windows and Xbox diehards.
Kevin Okemwa is a seasoned tech journalist based in Nairobi, Kenya with lots of experience covering the latest trends and developments in the industry. With a passion for innovation and a keen eye for detail, he has written for leading publications such as OnMSFT, MakeUseOf, and Windows Report, providing insightful analysis and breaking news on everything revolving around the Microsoft ecosystem. While AFK and not busy following the ever-emerging trends in tech, you can find him exploring the world or listening to music.
Excuse me, but annoying to who? To a very particular small group of users that should have known better than to use proper month names as their acronyms and to which excel has had a way to manage for only the last 30 years?Windows Central said:Microsoft is finally fixing an annoying Excel feature that data enthusiasts and scientists will appreciate. Users will now have the option to disable automatic conversions that convert their alphanumeric symbols into dates.
Scientists and data enthusiasts rejoice as Microsoft fixes one of Excel's most annoying 'features' : Read more
How sad that even on this site, there seems to be a joy in dissing anything that comes from Microsoft, you rarely see this type of write ups when it comes to the other tech companies: Google plasters you with advertisements and pop ups to get you to subscribe to their services and journalists report it as "Google increases advertising and marketing through its sites". Microsoft adds a small unintrusive one-time text for onedrive and journalists go "Microsoft once again trying to convert its properties into an advertising cesspool to try to force you to pay for uneeded services, ......."