Hi Folks

Am using Excel 2002.

I have a column of data like this:
5, 16, 27, 38, 39

Is it a fast and automatic way of turning all these into negative....
that reads
-5, -16, -27, -38, -39


Thanks!

put -1 in an empty cell
edit|copy (that cell)
select your range to fix
edit|paste special|check multiply
clean up that cell with -1 in it.

" wrote:

Hi Folks

Am using Excel 2002.

I have a column of data like this:
5, 16, 27, 38, 39

Is it a fast and automatic way of turning all these into negative....
that reads
-5, -16, -27, -38, -39

Thanks!

--

Dave Peterson

If the col of numbers is in col A,
we could also put in say, B1: =A1*-1, and copy B1 down
(Then use col B for further calcs, etc)

Or, if the col A may also contain negative numbers
which are to be left untouched (say),
then we could use instead in B1: =IF(A10,A1*-1,A1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
oups.com...
Hi Folks

Am using Excel 2002.

I have a column of data like this:
5, 16, 27, 38, 39

Is it a fast and automatic way of turning all these into negative....
that reads
-5, -16, -27, -38, -39


Thanks!

Or, if the values may already contain negatives, and you want to retain
those, if values start in A1, then type

=min(a1,-a1) into B1

and copy that down to the column

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=509673

"Mikeopolo" wrote:
Or, if the values may already contain negatives,
and you want to retain those, if values start in A1, then type
=min(a1,-a1) into B1

Much neater, thanks !

and even the earlier
... B1: =A1*-1

should also be just B1: = -A1 <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---