Excel: The error data type

Green triangle

A cell that contains an error is recognized by a green triangle in its upper left corner as shown in the the cell located at C3 in the following image:

Error values

Some (all?) excel error values are:

`#DIV/0`	Division by zero.
`#N/A`	A formula cannot find what it is supposed to look for.	This value is also returned by the worksheet function `=na()`.
`#NAME`	Unrecognized text
`#NULL`
`#NUM!`
`#REF!!`
`#VALUE!`
`#SPILL!`

Numbers stored as text

A number stored as text is also considered an error (it displays the green triangle) along with the number. The triangle can be removed (suppressed) in VBA or the Immediate window with variants of:

cells(r, c).errors(xlNumberAsText).ignore = true

or:

for each c in selection: c.errors(xlNumberAsText).ignore = true: next c

Excel: The error data type

Green triangle

Error values

Numbers stored as text

See also