Advanced Excel 2007
© Premier Training Limited 2002 – 2007
Each error value has different causes, and is resolved in
Text date with 2 digit years
The cell contains a text date that can be misinterpreted as the
wrong century when used in formulas. For example, the date
in the formula =YEAR("1/1/31") could be 1931 or 2031. Use
this rule to check for ambiguous text dates.
Number stored as text
The cell contains numbers stored as text.
These usually come from data imported from other sources.
Numbers stored as text can cause unexpected sorting
behaviours, and it is best to convert them to numbers.
Inconsistent formula in region.
The formula does not match the pattern of other formulas
near it. In many cases formulas that are adjacent to other
formulas only differ in the references used. If the references
used in a formula are not consistent with those in the adjacent
formulas, then the problem is noted.
Formula omits cells in region
The formula may not include a correct reference. If a formula
refers to a range of cells, and you add cells to the bottom or
right of that range, the references may no longer be correct.
The formula does not always automatically update its
reference to include the new cells. This rule compares the
reference in a formula, against adjacent cells. If the adjacent
cells contain more numbers (are not blank cells), then the
problem is noted.
Unlocked cells contain formulas
The formula is not locked for protection. By default, all cells