=IF(ISERROR(myformula),"",myformula)

or better still, there must be a cell that is dividing into something that
is 0, so test that cell

=IF(A1=0,"",B1/A1)

as an example.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"GJR3599" wrote in message
...
how can I make a #DIV/0! message either dissappear, be blank, or appear as
a
0.00 (or some other way of making it not look awful on a big spreadsheet)?