Change series of numbers from positive to negative

W

Wyatt Murphy

I have a series of postive numbers. All I want to do is change them to
negative. They are all independent from each other and different.
Thanks!
 
G

Gary''s Student

In an unused cell enter -1 and copy it.
Select the cells you want to change and
paste/special with the multiply button checked
 
M

Mladen_Dj

I have a series of postive numbers. All I want to do is change them to
negative. They are all independent from each other and different.
Thanks!

In blank cell enter -1, select it, copy, select range of cells with
positive numbers, go to Edit -> Paste special -> in Paste Special
dialog select Values and Multiply.
 
D

Dave Peterson

Put -1 in an unused cell
Edit|copy that cell

Select the range to fix
edit|paste special|check multiply

And clean up that cell with -1 in it.
 

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

Top