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

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.


---
Regards,
Norman



"jwoodruff77" wrote in message
...

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.


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"jwoodruff77" wrote in message
...

Hi Arvi,

Will this not convert negative values to positive values?


---
Regards,
Norman



"Arvi Laanemets" wrote in message
...
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.


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"jwoodruff77" wrote in message
...

"Norman Jones" wrote in message

Hi Arvi,

Will this not convert negative values to positive values?



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.

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.

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Gordon" wrote in message
...
"Norman Jones" wrote in message

Hi Arvi,

Will this not convert negative values to positive values?



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.