View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jason
 
Posts: n/a
Default How do I avoid fields being automatically filled in by default?

How do I avoid fields being automatically filled in by default? For example,
the formula for C1 is:

=SUM(A1-B1)

If nothing is yet entered in A1 or B1, then C1 is given the value "0"
I would like it to remain blank as a default.

Thanks again for your help

Jason