How do I make them all negative??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Edit>Pastespecial

click Values

OK

then delete column A

--
HTH

Bob Phillips

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