View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
tghcogo
 
Posts: n/a
Default Force a blank cell to zero


pinmaster Wrote:
Roz

Blank cells always equal 0. To prove it type =A1 in a cell, if A1 is
blank it will return 0.

Regards
JG


This is providing you have ticked the "zero values" box in
Tools/options/view - window options


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=495299