Share this article

Latest news

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

How to enable & use automatic data conversion in Excel

The feature is available to Windows and Mac users.

2 min. read

Published onOctober 20, 2023

published onOctober 20, 2023

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Microsoft Excel is getting a new automatic data conversion feature in Windows and Mac devices,according to the latest blogin the Microsoft 365 Insider program. This comes just days after the Redmond-based tech giant announced that itsCopilot AI will also debut on the platformstarting in November.

Automatic data conversion was already released to Excel, but now Microsoft is making the broadly available for all Windows and Mac Excel users out there.

Plus, the company improved the general layout of the feature, making it easier to find while also supporting more formats.

But this is not all. Microsoft made it possible for users to change Excel’s default options and even disable specific types of automatic data conversions.

Here’s how to enable & use automatic data conversion in Excel

Here’s how to enable & use automatic data conversion in Excel

To use the feature, first, you should check all the additional options in the Automatic Data Conversion panel, and enable those that you see fit for your needs.

After you’ve chosen your preferred options, there are many ways to use the new Automatic Data Conversion in Excel. For example, Microsoft recommends the following situation:

The feature is available to all users running Windows (Version 2309 or later) and Mac (Version 16.77 or later).

More about the topics:Microsoft Excel,Windows 11

Flavius Floare

Tech Journalist

Flavius is a writer and a media content producer with a particular interest in technology, gaming, media, film and storytelling.

He’s always curious and ready to take on everything new in the tech world, covering Microsoft’s products on a daily basis. The passion for gaming and hardware feeds his journalistic approach, making him a great researcher and news writer that’s always ready to bring you the bleeding edge!

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Δ

Flavius Floare

Tech Journalist

Flavius is a writer and a media content producer with a particular interest in technology, gaming, media, film and storytelling.