<< Click to Display Table of Contents >> Navigation:  Reference > Formats > CNZ Character to print for Nearly Zero

CNZ is a character format. The standard setting is CNZ'*'.

CNZ is used to set the character that is printed in a table when the value in the cell is not equal to zero, but so close to it that the relevant decimal place setting would mean it would otherwise appear as zero.

If the cell is a percentage cell, and CNZ is set to blank, then no percentage sign will be printed.

Any character can be allocated. Note that CNZ'0' has a special meaning and causes CL to honour the decimal place specification if set.

Format FNZ can be used to print a footnote on the page whenever this character is used.

See also formats:

CAZ Character to print for Absolute Zero (not percentages)

CZP Character to print for absolute Zero in Percentages

FNZ Footnote for Nearly Zeros