One way to achieve a clean visual, without plunging into error-trapping
individual formulae which are returning the error msgs, is to use
conditional formatting to mask the appearance

Try this:

Select A1, then press CTRL+A
Click Format Cond Formatting
Under condition1, make the settings:
Formula is: =ISERROR(A1)
Click Format button Font tab Font color white* OK
Click OK at the main dialog

*assumes the cells' fill color is either white or the default "no color"

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Evansct" wrote in message
...
I get error messages on many (if not most) of my spredsheet cells. Almost
all of them are unimportant or just plain nonsense. I can fix cell by
cell,
but that takes forever and should not be necessary. How can I globally
get
rid of this maddening nonsense?