View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lenny Lenny is offline
external usenet poster
 
Posts: 37
Default Cell formulas display "0" (zero's)

How can I get excel to not display a 0 (zero) in a cell with a simple
calculation like:
Z3+A4. I don't want the cells to display zeros before it displays the
calculation when entries are made into the formula cells and I don't want to
have to make the entries white to hide them. There's gotta be a way to not
show this value.

My thanks

Lenny