I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I
ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP.

Hi andresg1975

Enter -1 in a empty cell
Copy this cell

Select your data
Edit>Paste Special
Choose Multiply
OK


--
Regards Ron de Bruin
http://www.rondebruin.nl



"andresg1975" <(E-Mail Removed)> wrote in message news:420C0002-1105-43E0-8545-(E-Mail Removed)...
>I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I
> ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP.

Thanks a lot

"Ron de Bruin" wrote:

> Hi andresg1975
>
> Enter -1 in a empty cell
> Copy this cell
>
> Select your data
> Edit>Paste Special
> Choose Multiply
> OK
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "andresg1975" <(E-Mail Removed)> wrote in message news:420C0002-1105-43E0-8545-(E-Mail Removed)...
> >I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I
> > ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP.
>
>
>

Multiply the cells by -1.

If the range of cells is A1:A1000, then in column B, starting in B1, put
=A1*-1, and fill down as appropriate.
--
Brevity is the soul of wit.


"andresg1975" wrote:

> I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I
> ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP.

Hi

Cut your data from your actual column, select a cell in a helper column,
Paste it. Now copy your data from the helper column, select the cell in your
actual colum, Paste Special - "Subtract".

Jaleel



"andresg1975" wrote:

> I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I
> ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP.