Another way is to hide them using conditional formatting. Highlight
the cells you want to be affected in this way, then Format |
Conditional Formatting, then choose Cell Value Is, Equal To, 0 (zero),
then click the Format button and choose a foreground colour of white,
then OK twice. The cell will appear to be empty (white on white), but
the zero (and formula) is still there.

Hope this helps.

Pete

On Oct 7, 10:29 pm, JRID06 wrote:
I am trying to make it so if the result of a formula is 0 it will leave the
cell blank instead of a 0 showing up.



"JP" wrote:
Hello,

Don't type them...?

Sorry, not sure what you are trying to do.

--JP

On Oct 7, 5:11 pm, JRID06 wrote:
How do i make it so Zeros dont show up in excel- Hide quoted text -

- Show quoted text -