How to Stop Automatic Cell Formatting in Excel

To Stop Automatic Cell Formatting in Excel, you can use the AutoCorrect options and format cells as text.

This is an output overview.

Unchecking the AutoCorrect Dialog Box

Steps

Click the arrow button above the ribbon and select More Commands.
Go to Proofing.
Select AutoCorrect Options.
In the AutoCorrect window, click select the AutoFormat As You Type tab
Uncheck all options.
Click OK.
Excel stopped the auto formatting.

Note: If you enter a hyperlink in a cell, the AutoCorrect Options are displayed at the bottom left corner of the cell. Click it to undo or to stop creating hyperlinks. You can also go to the AutoCorrect dialog box.

Formatting Cells as Text

Steps

Select your dataset.
Press Ctrl + 1.
In the Format Cells dialog box, select Text and click OK.
Import or copy-paste data.
The cell format will not change automatically.

Frequently Asked Questions

Why does Excel automatically change the cell format?

Excel formats automatically by default.

How to stop Excel from formatting numbers with E 11?

Excel automatically formats numbers with an E 11 when the number contains 12 digits. To stop it:

Go to the Home tab.
Click on the Format Number drop-down list.
Select Number.

How do I format numbers in Excel?

To format numbers in Excel:

Select a cell.
Go to the Home tab.
Select Format cell.
Choose Number.

Download Practice Workbook

Download this practice workbook to exercise.

Stop Cell Format Changes Automatically.xlsx

Related Articles

<< Go Back to Excel Auto Formatting | Excel Cell Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!