how to change positive to negative in a range

I

Isabel-Bard

How can you change a range of numbers that were previously entered as
positive to negative?
 
G

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

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

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
 

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

Program buttons to create a word document 0
SUMIF with broken range 10
How to change numbers from positive to negative. 2
Subtracting positive amts from negative and positive from positive 3
Size & Position precision 0
Change positive to negative number 3
If sign of sum is negative change to positive 1
Counting consecutive negative value 7

Top