How do I make them all negative??

[RedLeader]

I have a column of numbers - some are postive numbers and others are negative
numbers. Ideally, I would like them all to be negative.
If I multiply by -1, then the negatives would become postive.I could format
cell, make all the negatives a different colour and then manualy change it -
with 3000 entries that becomes tedious...Any ideas?
Thanks

 

[Bob Phillips]

assuming the data is in A1:An

in B1, enter =-ABS(A1)

copy that formula down

select B1:Bn

goto Edit>Pastespecial

click Values

OK

then delete column A

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Roelof van Wyk]

use a simple if statement i.e.
=IF(A2<0,A2,A2*-1)