Presumably you have some formula in those cells. Replace the formujlas with
something like this:

=IF(ISERROR(<your formula),TRUE,<your formula)


On Wed, 9 Feb 2005 10:43:08 -0800, Diane Alsing
wrote:

I have a few formulas in a spreadsheet that are equal to #VALUE! which is
accurate, but is making my spreadsheet sloppy to read. Is there a way to
format cells to display a specific value if the cell value = #VALUE!. For
example, if cell W10=#VALUE! then display "TRUE" in the cell (instead of
#VALUE!).

Thank you.
Regards,
Diane