FORMULA ERROR AND AUDITING ANNOYANCES
TELL EXCEL WHAT IS AN ERROR AND WHAT ISNâT
Iâve figured out how to convince Excel to treat numbers I type into cells as text so that it doesnât delete leading zeros. But since I started using Excel 2002, when I copy those cells to another set of text-formatted cells the program marks the cells with an annoying green flag telling me thereâs some sort of nonfatal error or inconsistency. This problem never came up in Excel 97 or 2000, so I assume this is some new method Excelâs programmers came up with to torture me. Help!
To prevent Excel 2002 or 2003 from marking cells that store numbers as text with an error flag, select Tools â Options, select the Error Checking tab (shown in Figure 3-11), and uncheck the âNumber stored as textâ box.
FigureÂ 3-12.Â Use the Error Checking tabâs controls to avoid distracting cell markers in cells that donât really contain errors.
The Error Checking tab contains other checkboxes that prevent Excel from marking cells that exhibit other characteristics. The two you should consider unchecking immediately are âInconsistent formula in regionâ and âFormula omits cells in region.â These types of error flags are helpful for worksheets that summarize lists of data (e.g., sales by hour), but they arenât very helpful on summary worksheets that use data from all over a workbook. ...