Office Settings & Configuration

How to Disable Numbers Formatted as Text Warnings in Excel

Algirdas Jasaitis Sep 28, 2026 872 views

Question details

The user wants to hide the green triangle notifications that appear when numbers are intentionally entered into cells formatted as text.

How to Disable Numbers Formatted as Text Warnings in Excel

Product: Microsoft Excel for Microsoft 365
Device & OS: Windows
Scenario: Entering numerical identifiers (like zip codes or IDs) into cells formatted as text and encountering repetitive green triangle error warnings.
Observed behavior: Excel automatically flags numbers formatted as text with a green triangle indicating a potential calculation error.

Before you start

Ensure that disabling this global warning won't impact other parts of your spreadsheet where identifying accidental numbers formatted as text is crucial for formulas and calculations.

Solution 1Recommended

Turn off the 'Numbers formatted as text' Error Checking Rule

Use Excel's global Options menu to disable the specific error checking rule for text-formatted numbers.

By modifying the background error checking rules, you can permanently stop Excel from displaying the green triangle on text-formatted number entries. This is particularly helpful when working with IDs, phone numbers, or zip codes.

Open Excel Options

Click on the 'File' tab in the top-left corner of the Excel ribbon, then select 'Options' at the bottom of the menu.

Navigate to Formulas

In the Excel Options dialog box, select 'Formulas' from the left sidebar to access calculation and error-checking settings.

Locate Error Checking Rules

Scroll down to the section labeled 'Error checking rules'.

Disable the Warning

Clear the checkbox next to 'Numbers formatted as text or preceded by an apostrophe'.

Save Changes

Click 'OK' at the bottom of the window to apply the new settings to your Excel application.

Turn off the 'Numbers formatted as text' Error Checking Rule

Global Setting: This setting applies to your entire Excel application on this Windows device. It will disable the warning across all workbooks you open, not just the current file.

Manage Error Warnings Easily in WPS Spreadsheet

WPS Spreadsheet offers a highly compatible and user-friendly interface to manage background error checking, allowing you to effortlessly disable unwanted green triangle warnings just like in Excel.

1. Open Options: Open your workbook in WPS Spreadsheet, click the 'Menu' button in the top left corner, and select 'Options'.
2. Go to Error Checking: Navigate to the 'Error Checking' tab in the options window.
3. Disable the Rule: Uncheck the rule for 'Number stored as text' and click 'OK' to save your preferences.

Fully compatible with Microsoft Excel formats (.xlsx, .xls)Granular control over error checking and cell formatting rulesFree to use with a lightweight installation and fast startupFamiliar user interface requires no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show a green triangle when I type numbers?

Excel automatically checks for common data entry anomalies. When it sees numerical characters in a cell formatted as text, it assumes you might have made a mistake that will prevent the number from being used in mathematical calculations, flagging it with a green triangle.

Can I ignore the error for just one specific cell instead of disabling it globally?

Yes. Click the specific cell displaying the green triangle, click the warning icon (an exclamation mark inside a yellow diamond) that appears beside it, and select 'Ignore Error' from the drop-down menu.

How do I convert text numbers back to regular numbers to remove the warning?

Highlight the cells with the green warning triangles, click the yellow exclamation mark warning icon that appears next to your selection, and choose 'Convert to Number'. This will change them back to standard numerical values and remove the warning.

Office App Problems