In print preview I can see all of the error value why is this and.
 

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!

Is there a reason you save as 97, that will bloat the workbook,
save as Microsoft Excel Workbook unless you need to be able to open it in
excel 5 and 95 and 2000.


Regards

Peo Sjoblom

"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!

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!