Turn Off Auto Formatting in Excel: Step-by-Step Guide

Turn Off Auto Formatting in Excel is easier when you confirm the requirements, prepare the right tools, and follow each step in the correct order.

This updated guide explains the process clearly, highlights common mistakes, and provides practical checks that can help you get a reliable result.

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.

Instructions to Turn Off Automatic Formatting on Excel screenshot

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:

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

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

Instructions to Turn Off Automatic Formatting on Excel screenshot 2

FAQ

What should I prepare before working with Turn Off Auto Formatting in Excel?

Review the requirements, back up important data when relevant, and confirm that your device, account, or software supports the steps in the guide.

What should I do if a step does not work?

Repeat the step carefully, verify each setting, restart the affected device or application, and check for newer compatibility information.

Is the process safe?

The process is generally safe when the instructions are followed carefully. Avoid unofficial downloads and stop before making changes that could affect important data.