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

assuming the data is in A1:An

in B1, enter =-ABS(A1)

copy that formula down

select B1:Bn

goto EditPastespecial

click Values

OK

then delete column A

--
HTH

Bob Phillips

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

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

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