How to remove the green triangle in the upper left corner of excel table

Removal method: First select the cells that need to be processed. After selecting, a small box with a "!" will appear in the upper left corner of the cell; then click the small icon and click in the pop-up menu "Ignore errors" or "Convert to number" will remove the green triangle.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

Related learning recommendations: excel tutorial

Present the green triangle in the upper left corner of excel

First, let’s look at the upper left corner of excel The green triangle looks like the screenshot below.

Explanation of the reason why the small triangle appears in the upper left corner of excel

The reason why the small triangle appears in the upper left corner of excel: Green triangle indicates This cell is a text type number. This type of number cannot be directly calculated. For example, if we write the formula: =SUM(A2:A11), we will get a sales volume of 0 in January, which is obviously incorrect.

How to solve the problem of the green triangle in the upper left corner of excel

First of all, we don’t have to worry about the printing problems caused by the green triangle in the upper left corner. What is printed is only displayed on the screen.

If you insist on removing it, you can click the cell with the green triangle in the upper left corner. After clicking, a small box with a ! symbol will appear in the upper left corner of the cell. Click the small icon, click "Ignore errors" in the options to remove the green triangle. After clicking, you will find that the green triangle symbol in the upper left corner of the previous cell is missing, which means that the number in this cell has been converted to a normal numerical format.

If you want to batch remove the green triangle symbol in the upper left corner of the cells, then first select all the cell areas with the green triangle in the upper left corner of excel, and then operate.

PS: If subsequent operations are required, please select the "Convert to Number" option instead of the "Ignore Error" option.

To read more related articles, please visit PHP Chinese website! !

The above is the detailed content of How to remove the green triangle in the upper left corner of excel table. For more information, please follow other related articles on the PHP Chinese website!