How to change positive numbers to negative numbers without re-ente

Please help!

Place "-1" into an empty cell, copy it, then select your range of positive
numbers and "Paste Special"->Multiply


--
Regards,
Dave


"9541moosegirl" wrote:

> Please help!

First, in the future, please ask your question in the body of the post and
only put a short subject in the subject line.............

All I can see of your post is
"How to change positive numbers to negative numbers without re-ente......"

So, to do that, type -1 in an unused cell somewhere, then highlight it and
do COPY....
Then highlight the cells you wish to change from positive to negative and
then right-click and do PasteSpecial > Multiply............

Vaya con Dios,
Chuck, CABGx3



"9541moosegirl" wrote:

> Please help!

In a cell alongside, add

=IF(A1>0,-A1,A1)

and copy down.

Then select column B, Copy, Edit>Pastespecial>Values.

Then delete column A.

--

HTH

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


"9541moosegirl" <9541moosegirl@discussions.microsoft.com> wrote in message
news:834691B8-DAE5-4DF1-B9B8-02B634F042E7@microsoft.com...
> Please help!

You could also use the formula abs(A1) which is the absolute value of
A1 and will always be positive.

- John

Which does exactly the opposite of what was asked.

--

HTH

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


"John Michl" <waxwing1@gmail.com> wrote in message
news:1134063329.165111.126780@g43g2000cwa.googlegroups.com...
> You could also use the formula abs(A1) which is the absolute value of
> A1 and will always be positive.
>
> - John
>

Thanks Bob. I guess I'm dyslexic today.

Thank You Thank You thank you!!! You have saved me soooo much work!

"David Billigmeier" wrote:

> Place "-1" into an empty cell, copy it, then select your range of positive
> numbers and "Paste Special"->Multiply
>
>
> --
> Regards,
> Dave
>
>
> "9541moosegirl" wrote:
>
> > Please help!