How to remove green triangles from cells (hide auto-calculating checks)
This green triangle identifies the possible error, but often it doesn't useful.
To turn off these green triangles or auto-calculating checks, do the following:
1. On the File tab, click the Options button:
2. In the Excel Options dialog box, on the Formulas tab, scroll down to the Error Checking section and uncheck the option Enable background error checking:
This is an application level setting and will apply to all open workbooks in the Excel session.
Note: You can uncheck just some auto-calculating checking rules. For this example, it is enough to uncheck the rule Numbers formatted as text or preceded by an apostrophe: