Custom Format N/A #DIV/O!
"vane0326" wrote in
message ...
I would like to know if there is a custom format that will hide formula
errors. I'm not talking about conditional formatting.
Example:
This will hide Zero's
0;-0;;@
This will hide the The Bignum (E+307)
[=9.99999999999999E+307]"";General
But what will hide
#N/A and #DIV/O!
What do you think*?*
--
vane0326
Hi!
I'm gonna take a guess and say that is not possible. Formats are for numbers
and text. Those error types are neither. Errors such as those mentioned are
LOGICAL values. They are not numbers and they are not text.
Biff
|