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

Please help!

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

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!

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

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!

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

In a cell alongside, add

=IF(A10,-A1,A1)

and copy down.

Then select column B, Copy, EditPastespecialValues.

Then delete column A.

--

HTH

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


"9541moosegirl" wrote in message
...
Please help!

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

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

- John

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

Which does exactly the opposite of what was asked.

--

HTH

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


"John Michl" wrote in message
oups.com...
You could also use the formula abs(A1) which is the absolute value of
A1 and will always be positive.

- John

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

Thanks Bob. I guess I'm dyslexic today.

How to change positive numbers to negative numbers without re-
 

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!

How to change positive numbers to negative numbers without re-
 

"John Michl" wrote:

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!