If there are a lot of formulas here, you can avoid recoding them to the
suggested formulas by simply selecting them all, use Format/Conditional
Format, and, using the active cell's address, say C1, change "Cell Value
is", to "Formula Is", then enter =ISERROR(C1), click Format button, click
the Font Tab if necessary, and choose a white font (or whichever one matches
the background), then OK your way out. All errors won't show.

"renold1958" wrote in message
...
Have a spreadsheet....one column keeps coming up with #DIV/0!.........I
know
reasons as of to why, etc etc............is there anyway have the #DIV/0!
values disappear from a column?