Change positive to negative number

S

Sandra

I'm using Excell 2007 and I need to change a column of positive numbers to
negative numbers.
 
D

damien.benoit

I'm using Excell 2007 and I need to change a column of positive numbers to
negative numbers.
Click to expand...

I have a huge list of prices and alot are- negative but are't supposed to be, how can I do it to alot at once? Thanks!
 
L

Lisa Wilke-Thissen

Hi,

[Excel 2007]
I have a huge list of prices and alot are- negative
but are't supposed to be, how can I do it to alot at once?
Click to expand...

Apply Filter just to show numbers smaller than 0.
Then copy a "-1" to clipboard. Select the filtered result, and choose "Paste
special | Mulitply".
(See
http://www.techrepublic.com/blog/mi...perform-calculations-while-pasting-in-excel/#,
http://www.mrexcel.com/articles/paste-special-add-operation.php)

Alternative:
In an additional column use following formula:
=IF(A2<0;A2*-1;A2)
Then copy this column and paste just values into the other column.
 

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
How to change numbers from positive to negative. 2
Excel 1
Subtracting positive amts from negative and positive from positive 3
subtract a positive from a negative 7
I have a column of 50 numbers 5
How to count the maximum number of consecutives? 9
Reverse value in a column 1

Top