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:	Re: Display negative numbers enclosed in parenthesis in Excel97.
From:	Russ Poffenberger <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Mon, 20 Sep 1999 09:11:15 -0700
Content-Type:	text/plain
Parts/Attachments:	text/plain (24 lines)

K. Gladstone wrote:

>I am developing a spreadsheet to replace a paper based cashbook and VAT day
>book.
>I am reliably informed that in accounting a negative number should be
>identified by placing it in parenthesis,
>I understand that a negative number can be entered by enclosing it in
>parenthesis but as soon as I change to the next cell or press enter the
>parenthesis disappear and a minus sign precedes the number.

Easy, select the cell or cells that you want to display negative numbers in
paranthesis, from the menu, select "Format -> Cells". In the dialog box that
comes up, in the list of field types, select "number", and you have a choice
of different representations for negative numbers.

Russ Poffenberger               Engineering Specialist
Schlumberger Technologies ATE   DOMAIN: [log in to unmask]
1601 Technology Drive
San Jose, Ca. 95110             Voice: (408)437-5254  FAX: (408)437-5246

             PCSOFT maintains many useful files for download
                     visit our download web page at:
                     http://nospin.com/pc/files.html

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG