Excel

B

Bear

Without manually changing each entry how do I change a column of positive
numbers to negative numbers.

Thanks in advance
Bear
 
J

Joe User

Bear said:
Without manually changing each entry how do I
change a column of positive numbers to negative
numbers.
Click to expand...

Enter -1 into some cell, and copy it. Select the column or range of cells
to be changed, right-click, and click Paste Special > Multiply > OK. You can
now delete the -1.
 

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

Counting consecutive negative value 7
I have a column of 50 numbers 1
I have a column of 50 numbers 5
Change positive to negative number 4
How to average the last 10 numbers in a row? 9
calculating total in a column 2
Reverse value in a column 1
Converting positive numbers to negative numbers 4

Top