Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Excel 97 zero to replace minus
From:	Mick Fitzpatrick <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Wed, 8 Oct 2003 19:19:53 +0100
Content-Type:	text/plain
Parts/Attachments:	text/plain (21 lines)

Hello

I have a simple Excel 97 spreadsheet that adds up a few rows ... real basic
stuff

In the bottom box I show the total ... sometimes this can be a minus figure
and Excel 97 will display as    -33

What I would like to do is show zero for any minus total ... so rather than
display -33 it will display 0 but still display any totals over zero

Is it possible to do this?

I hope I have made myself clear

TIA ... Mick

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                   http://freepctech.com/pcsoft.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG