change signs in a column of numbers

B

bob

I have a column of figures that includes both positive and
negative numbers. I want to change the positive numbers
to negative ones, and vice-versa. Any way to do this in
Excel 2002?

Thanx.
 
J

JON JON

Type -1 to any empty cell
Copy that cell
select the range that you will change the number sign
On the worksheet menu, EDIT > PASTE SPECIAL
Choose values and multiply, click OK
 
C

Chip Pearson

Bob,

Enter -1 in some empty cell and copy it. Then, select the cells you wish to
change, and go to the Edit menu, choose Paste Special, and choose the
Multiply option. Finally, delete the -1.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Flipping numeric values 3
Excel - Adding positive or negative numbers in a column 5
Trying to reconcile a column 1
Coloring cells 8
Can I automatically change all positve numbers to negative number. 2
How do I convert numbers to the opposite sign? 3
Negative Numbers 8
REVERSING SIGNS OF NUMBERS 14

Top