Path: csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From: Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups: comp.databases.filemaker
Subject: Re: Borders
Date: Sat, 09 May 2015 09:58:47 +1200
Organization: Aioe.org NNTP Server
Lines: 27
Message-ID: <090520150958473976%HelpfulHarry@BusyWorking.com>
References: <1m3g6lv.10ue4iznysxglN%csampson@inetworld.net> <1m43ss4.47rpi6adeebkN%csampson@inetworld.net>
NNTP-Posting-Host: oAnvKUrfXr75V3Jo8+zWOg.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Thoth/1.8.4 (Carbon/OS X)
X-Notice: Filtered by postfilter v. 0.8.2
X-Face: vIZzK[X\z-._]-_:U?l@cBtwg<{a>ggn\mH}Vs>38E,#R%7h%U0'=4;1Q=erO %[T#a{YJfGvAbWmE@f_h]<rQ30+q;vqA^FUVx%\9{@r{gt${p^.L~bemFF@WY$r9fhuA F"1)$0+MgN+j8OO<SAec%$P;!M4Aj/kVitK5\xKmed-/3$2LiT1nI!-lKjt0B!qP_E{V ja+\#+[_uq8",IkoIF3M0}}qCD(&
Xref: csiph.com comp.databases.filemaker:2316

In article <1m43ss4.47rpi6adeebkN%csampson@inetworld.net>, Charles H.
Sampson <csampson@inetworld.net> wrote:
> 
> Follow-up. I used the white-on-white technique, which Helpful Harry
> pointed out could be useful, in another context. I have a table in Word
> that has a couple of cells that have the value 0 in them. This is
> because I want to sum the numbers in those cells'  column and Word won't
> sum past a blank. It's always irritated me to see those "pointless"
> zeros sitting there. I formatted the text to be white (on the white
> background). The zeros are still there but they're not visible now.

I'm not sure about Word or whatever version your using (I've never
bothered to have tables that include formulas), but in Excel you can
either:

    - change the cell's number format to not display a zero,

or  - conditionally format the cell to display zeros as
      white, and other numbers in black (or whatever colour),

or  - use a cell formula with an If statement instead of just 
      the standard Sum function so that it doesn't show zero
      totals.
      i.e.   If (Sum(range) = 0 , "", Sum(Range))


Helpful Harry  :o)