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

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?

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

"bmordy" <[email protected]> wrote in message
news:[email protected]...
>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?
>

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.

In article <[email protected]>,
bmordy <[email protected]> wrote:

> 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?

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.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"bmordy" <[email protected]> wrote in message
news:[email protected]...
>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?
>

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)


"bmordy" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

Works slick!
Thanks

"bmordy" wrote:

> 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?
>

Looks as though Bernard has the fastest buzzer, Alex.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Bernard Liengme" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> "bmordy" <[email protected]> wrote in message
> news:[email protected]...
>>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?
>>
>
>