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

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
 
G

Guest

Jason,

Go to:

Tools > Options, specifically the "View" tab

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

Steph
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

somewhat complicated conditional formula 2
Retrieve last non zero value in a range of cells 2
lock cells 2
Time Calculations Help 4
How to get info filled in automatically 2
How do I Create a formula for greater or lesserthen 1
sum values from range of cells if cells correcponding have the sam 15
if.... Anyway around this? 2

Top