View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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