Mac Excel Version 16.78: Control Data Conversions?

Question

Can anyone tell me where to find this new feature on Excel for Mac please? All the instruction I can find relate only to the Windows version.

October 10, 2023

Version 16.78 (Build 23100802) Feature updatesExcel

• Control your data conversions: You’ve been asking for more control over how Excel automatically converts your data to specific formats. We delivered! You now have the ability to disable specific types of automatic data conversions; this way, you won’t need to worry about Excel converting your data to a format that you didn’t want and weren’t expecting.

Answer 1

Hi,

The Control Data Conversions feature is available in Excel for Mac version 16.78 (Build 23100802). To access this feature, you can follow these steps:

1. Open Excel for Mac version 16.78.
2. Click on the "Excel" menu in the top left corner of the screen.
3. Select "Preferences" from the drop-down menu.
4. In the Preferences window, click on the "Edit" tab.
5. Under the "Edit" tab, you should see an option for "Control Data Conversions."
6. Click on "Control Data Conversions" to access the feature and disable specific types of automatic data conversions.

I hope this helps! Let me know if you have any further questions.