View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vane0326 vane0326 is offline
external usenet poster
 
Posts: 1
Default Custom Format N/A #DIV/O!


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
------------------------------------------------------------------------
vane0326's Profile: http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=562310