单元格有一个以文本形式存储的数字。 Excel是警告你，你不能对格式化为文本单元格的数字做数学公式。因为它听起来像你真的想要数字作为基于你的宏的文本，你可以关闭在Excel中的错误检查，摆脱那些讨厌的绿色三角形：

The green triangle indicates that the cell has a number that's stored as text. Excel is warning you that you can't do math formulas on numbers that are formatted as text cells. Since it sounds like you actually want numbers as text based on your macro, you can turn off error checking in Excel to get rid of those pesky green triangles:

1. 单击文件选项卡。


2. 在帮助下，单击选项。
   
3. 在Excel选项对话框中，单击公式 / li>
   
4. 点击错误检查规则，清除格式设置为文本的数字或在撇号前加上复选框。
   
5. 单击确定。 b

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