How do I make the 0 hidden with erasing the formula in a block?

F

floydgrading

Please help asap. I have a project due and I dont want all those zeros on
the page but I dont want to erase all my formulas. I need them there for
when I plug in my numbers.
 
R

RogerN

How about the simple expediant of going to Tools/Option/View and deselecting
"Zero values".

Roger
 
P

Peo Sjoblom

The drawback with that is that it affects the whole sheet as opposed to
custom formatting
 
Top