G
Guest
How do i make it so Zeros dont show up in excel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JP
Hello,
Don't type them...?
Sorry, not sure what you are trying to do.
--JP
Don't type them...?
Sorry, not sure what you are trying to do.
--JP
G
Guest
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.
cell blank instead of a 0 showing up.
C
Chip Pearson
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;
"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;
G
Gord Dibben
=IF(yourformula=0,"",yourformula)
e.g. +IF(A1-B1=0,"",A1-B1)
Watch this..........0 may be just a formatting issue and you really have
0.0000000123 in the cell.
Gord Dibben MS Excel MVP
e.g. +IF(A1-B1=0,"",A1-B1)
Watch this..........0 may be just a formatting issue and you really have
0.0000000123 in the cell.
Gord Dibben MS Excel MVP
P
Pete_UK
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
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
S
SteveM
Great to see some humor here
JP said:Hello,
Don't type them...?
Sorry, not sure what you are trying to do.
--JP