Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #2316

Re: Borders

Show all headers | View raw

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)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Borders csampson@inetworld.net (Charles H. Sampson) - 2015-04-25 18:54 -0700
  Re: Borders Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-04-26 14:00 +1200
    Re: Borders csampson@inetworld.net (Charles H. Sampson) - 2015-04-27 23:06 -0700
      Re: Borders Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-04-28 18:38 +1200
  Re: Borders csampson@inetworld.net (Charles H. Sampson) - 2015-05-08 12:50 -0700
    Re: Borders Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-05-09 09:58 +1200
      Re: Borders Thibaud Taudin Chabot <tchabot@hccnet.nl> - 2015-05-09 07:38 +0200

csiph-web