How can you change a range of numbers that were previously entered as positive to negative?
I Isabel-Bard Oct 7, 2004 #1 How can you change a range of numbers that were previously entered as positive to negative?
G Govind Oct 7, 2004 #2 Hi, Type -1 in some cell, copy that and then paste special in the range where you have the numbers. Do a Paste Special -> select "values" in paste and then choose "Multiply" in Operation. Regards Govind.
Hi, Type -1 in some cell, copy that and then paste special in the range where you have the numbers. Do a Paste Special -> select "values" in paste and then choose "Multiply" in Operation. Regards Govind.
N Nitin Harkawat Oct 7, 2004 #3 If you data begins on A1 on a separate area on worsksheet enter =if(A1>0,-1*a1,a1) Copy this formula across all the rows and columns Then select this block of data , copy it and on cell A1 go to Edit>Paste special -> values
If you data begins on A1 on a separate area on worsksheet enter =if(A1>0,-1*a1,a1) Copy this formula across all the rows and columns Then select this block of data , copy it and on cell A1 go to Edit>Paste special -> values
P Paul Corrado Oct 7, 2004 #4 Put a -1 in an empty cell and select Edit/Copy Highlight the range of cell values you wish to change Select Edit/Paste Special and check the Multiply option Click OK
Put a -1 in an empty cell and select Edit/Copy Highlight the range of cell values you wish to change Select Edit/Paste Special and check the Multiply option Click OK
