Turn a row of numbers into negative value

D

dstdst123

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!
 
D

Dave Peterson

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.
 
M

Max

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(A1>0,A1*-1,A1)
 
M

Mikeopolo

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
 
M

Max

Mikeopolo said:
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
Click to expand...

Much neater, thanks !

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

should also be just B1: = -A1 <g>
 
Top