How do I change a large number of cells from a postive to a neget.

[Guest]

I need to quickly change many cells from a positive number to a negetive
number.
For example 20 to -20.
What is the most efficient way to do this?

 

[Bernard Liengme]

In a blanks cell enter the value -1
Copy this cell
Select all the 'problem' cells
Use Edit | Paste Special and specify multiply
Now delete the cell with -1

best wishes
Bernard

 

[JE McGimpsey]

Enter -1 in an empty cell. Copy the cell. Select your data. Choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.
Click OK.

 

[Earl Kiosterud]

mordy,

Put -1 in a cell, select it, Copy. Now select the cells to be changed.
Edit - Paste Special, Multiply. Now you can delete the original cell.

 

[Bob Phillips]

In another cell put -1
Copy that cell
Select all cells to convert
Edit>PasteSpecial and select the Multiply option.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Works slick!
Thanks

 

[Earl Kiosterud]

Looks as though Bernard has the fastest buzzer, Alex.