Go to the Tools menu, choose Options, then the View tab, and uncheck the
"Zero Values" option. This will hide ALL zero values that are the result of
a calculation. To hide zeros only on certain cells, format those cells with
the following custom number format. Note the trailing semi-colon.

General;General;




"JRID06" wrote in message
...
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