How to turn off auto formatting in Excel

For example, when you enter the number 0 in Excel, the number 0 automatically disappears. Below are instructions for turning off automatic formatting in Excel.

Instructions to turn off automatic formatting on Excel

Step 1:

At the Excel interface, click on File then click on Options in the displayed list.

Step 2:

Switch to the interface of the Excel settings. We click on the Data item , then look to the side to find the Automatic Data Conversion item and we will see the content automatically formatted as below.

You can enable or disable automatic formatting in this interface.

We can uncheck the setting Enable all default data conversions below when importing, pasting, or loading text into Excel to turn off all automatic formatting when importing data into the content.

There are also other sub-settings below with the contents:

1. Remove leading 0's from numeric text and convert to number.
2. Truncate numeric data to 15 digit precision and convert to numbers that can be displayed in scientific notation if necessary.
3. Converts numeric data around the letter 'E' to numbers displayed in scientific notation.
4. Converts a continuous string of letters and numbers into a date.

Currently the new feature is only being deployed for Office 365 versions.

Kareem Winters

Update 12 September 2024