How do I convert numbers to the opposite sign?

G

Guest

I need to change all positive numbers in the spreadsheet to negative numbers,
and vice versa in Excel.
 
D

Dave Peterson

Put -1 in an empty cell
edit|copy that cell
select your range to fix
Edit|paste special|check multiply.
 
G

Guest

Type a '-1' in some random cell and copy it (ctrl+C). Then select the cells
you want to switch and Edit > Paste Special, select Values and Multiple and
click OK.
 

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
Can I automatically change all positve numbers to negative number. 2
How do I display a "+" in front on positive numbers 3
Convert positive # to negative 1
Negative Numbers 8
Coloring cells 8
change signs in a column of numbers 2
Subtotal data excluding negitive numbers. 3

Top