No zero in a cell
You can either adjust the formula, like =IF(SUM(A1:A10)=0,"",SUM(A1:A10), or
you can turn off zero display, ToolsOptions and on the View tab uncheck the
Zero Values box.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Michael" wrote in message
...
Help to a code in Exell.
Exell make a zero in every cell if there not are some sum to take.
What code must I make if I want a empty cell every time it is zero
--
I hope someone can help me.
Mvh.
Michael
|