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:	change negative to positive in Excel
From:	Tony Beckett <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Tue, 30 Aug 2005 11:50:06 +0100
Content-Type:	text/plain
Parts/Attachments:	text/plain (24 lines)

Mark asked about changing  a range of negative numbers to
positive in Excel.

Dean suggested using the absolute value function ABS to do
the job.

How about using Edit/Replace and looking for - and then not
replacing it with anything?

Done this way it doesn't involve a function or using an
extra column to get the job done.

It doesn't seem very "mathematical" though. Are there
likely to be problems if it is done this way?

Regards

Tony
Tony Beckett - Rutland, UK

                Curious about the people moderating your
                   messages? Visit our staff web site:
                    http://freepctech.com/staff.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG