Jacqueline

Can you see the #VALUE! when not in print preview?

If you haven't hidden the error then you will see it and print it.

Errors can be hidden using Conditional Format or by means of a formula.

=IF(ISERROR(A1+B1),"",A1+B1) would show a blank cell if there is an error.

Conditional Formatting method...

FormatCellCFFormula is: =ISERROR(cellref)

Hit Format button and FontColorWhite. OK your way out.

Gord Dibben Excel MVP



On Thu, 9 Dec 2004 14:25:04 -0800, "Jacqueline"
wrote:

using 2000 put saving it as excell 97
The black & white is not check on sheet set up
Draft is not checked either



#value! #value!