How do I avoid fields being automatically filled in by default?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Jason,

Go to:

Tools > Options, specifically the "View" tab

Make sure the "Zero values" checkbox is deselected. That should take care
of it.

Steph
 
Back
Top