Change a positive number to negative number

  • Thread starter Thread starter patowens
  • Start date Start date
P

patowens

I have a column of positive numbers that I need to change to negativ
numbers. Is there an easy way to do this? Right now I manualy make th
change. Thank you, Pa
 
patowens, put -1 in an empty cell, copy that cell, select the numbers you
want to change, right click and paste special, check multiply, OK.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Try the following...

1) Enter -1 (minus one) in an empty cell

2) Select that cell

3) Edit > Copy

4) Select your column of positive numbers

5) Edit > Copy > Paste Special > Multiply > Ok

Hope this helps!
 
Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Back
Top