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

[9541moosegirl]

Please help!

 

[David Billigmeier]

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

 

[CLR]

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

 

[Bob Phillips]

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)

 

[John Michl]

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

- John

 

[Bob Phillips]

Which does exactly the opposite of what was asked.

--

HTH

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

 

[John Michl]

Thanks Bob. I guess I'm dyslexic today.

 

[Raich]

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

 

[Diana A.]

Thanks Bob. I guess I'm dyslexic today.

Actually, this answered what I was looking for on this discussion page. There were many posts of positive to negative but this is the first I saw of negative to positive. Thanks!