LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 36
Default Autosum automatically enters zero

I created a form that calculates a total in the right column. Every cell in
that column starts out with a "zero" in it until numbers are entered in the
other columns that need to be totaled. I want it blank until numbers are
entered and there is an actual result in the right column. How do I get rid
of the "zeros" in the total column on the right?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 sp2 autosum gets inserted automatically David Stirling Excel Worksheet Functions 1 November 10th 07 12:58 AM
Mouse click automatically enters character into cell. Jeffrey M. Coffin Excel Worksheet Functions 10 June 27th 07 02:56 AM
Date enters wrong #'s Frustrated_rich99 New Users to Excel 2 December 7th 06 01:06 PM
find/replace enters search Excel Discussion (Misc queries) 2 January 31st 06 08:24 PM
Master worksheet automatically enters data into sub worksheets Ken Excel Discussion (Misc queries) 1 November 1st 05 10:36 PM


All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"