S
Sandra
I'm using Excell 2007 and I need to change a column of positive numbers to
negative numbers.
negative numbers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
=-ABS(A1)
S
Sandra
D
damien.benoit
I'm using Excell 2007 and I need to change a column of positive numbers to
negative numbers.
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]
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.
[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?
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.