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

's Computer Specifications

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

's Computer Specifications

Jason,

Go to:

Tools > Options, specifically the "View" tab

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

Steph

"jason" wrote:

> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Avoid counting #N/A filled cells, or avoiding #N/A altogether	fr8dog	Microsoft Excel Worksheet Functions	5	10th Aug 2008 12:03 AM
Fields filled with ########	=?Utf-8?B?cGVudG9udGVjaGd1eQ==?=	Microsoft Access Queries	1	27th Sep 2007 05:09 PM
Fields to be Filled in	=?Utf-8?B?QW5kcmV3IEM=?=	Microsoft Access Forms	7	3rd May 2007 01:03 PM
Chil/master fields filled automatically and cause a subform query to fail	bob bob via AccessMonster.com	Microsoft Access Form Coding	4	21st Feb 2005 03:31 PM
Zero filled fields	Cookie	Windows XP General	0	18th Aug 2003 11:40 PM