Turn Off Error Checking For Number

With error checking turned on in Excel, you see a small green triangle if you enter a number into a cell that has text formatting applied to it. If you don’t want to see these error indicators, you can turn them off.

 

 

To Turn off error checking for Number formatted as text:

• Click the File tab.
• Under Help, click Options.
• In the Excel Options dialog box, click the Formulas category.
• Under Error checking rules, clear the Numbers formatted as text or preceded by an apostrophe check box.
• Click OK.

Posted in: Microsoft Excel 2007,Microsoft Office Support,number in text formatted cell,PC Support,Technical Support,TechSupp247,turn off error checking,Turn off error checking for Number in text format