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

J

Jacqueline

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

Peo Sjoblom

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
 
G

Gord Dibben

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...

Format>Cell>CF>Formula is: =ISERROR(cellref)

Hit Format button and Font>Color>White. OK your way out.

Gord Dibben Excel MVP
 
Top