How do I make all numbers in a column negative in excel 2000?

N

Norman Jones

H J,

Assume the values start in A2,

B2: = -Abs(A2)

and drag down as far as required.

For column B use any other convenient column.

Copy | PasteSpecial | Values the formla cells, either in situ or to replace
the original column A values.
 
A

Arvi Laanemets

Hi

Enter -1 into any free cell, and copy the cell.
Select your column.
Select PasteSpecial from menu, or from right-click dropdown list, and check
Multiply. OK.
 
G

Gordon

Norman Jones said:
Hi Arvi,

Will this not convert negative values to positive values?
Click to expand...

It will. The OP needs to do an IF statement in a free column as
=IF(A1<0,A1*-1,A1) and then do a copy-paste special-values I think.
 
A

Arvi Laanemets

Hi

Another way, when there are initially negative values in column, is to
select the column , and replace all "-" with nothing. After that OP can
continue multiplying the column with -1.
 
Top