| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding custom format | Excel Discussion (Misc queries) | |||
| Need Custom format, not a formula | Excel Discussion (Misc queries) | |||
| Custom Cell Format | Excel Discussion (Misc queries) | |||
| Custom Number Format Text | Excel Discussion (Misc queries) | |||
| Custom Time Format doesn't work for me | Excel Discussion (Misc queries) | |||
Threaded Mode
