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(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!

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

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!

"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!