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 Function
From:	Tony Beckett <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Thu, 15 Feb 2007 08:33:49 -0000
Content-Type:	text/plain
Parts/Attachments:	text/plain (23 lines)

Maurice Reid asked how to change a column of numbers from 
positive to negative in one fell swoop.

You don't use one of the built in function for this.

In an empty cell type   -1
Then copy the -1 cell, highlight the cells you wish to turn 
minus and choose Edit/Paste Special. In the "Operation" 
section of the dialogue box select "Multiply" and the job 
is done.

You could select the whole column where you want the 
numbers made negative but if you do any blank cells will 
have a zero put in them.

Tony
Tony Beckett
Rutland, UK

        The NOSPIN Group has added a new feature on our website,
           web based bulletinboard for questions and answers:
              Visit our sister website at http://nospin.com

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG