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

Signature
Regards,
Dave
> Please help!
Raich - 01 Apr 2006 10:16 GMT
Thank You Thank You thank you!!! You have saved me soooo much work!
> Place "-1" into an empty cell, copy it, then select your range of positive
> numbers and "Paste Special"->Multiply
>
> > 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
> 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.

Signature
HTH
RP
(remove nothere from the email address if mailing direct)
> Please help!
John Michl - 08 Dec 2005 17:35 GMT
You could also use the formula abs(A1) which is the absolute value of
A1 and will always be positive.
- John
Bob Phillips - 08 Dec 2005 18:01 GMT
Which does exactly the opposite of what was asked.

Signature
HTH
RP
(remove nothere from the email address if mailing direct)
> You could also use the formula abs(A1) which is the absolute value of
> A1 and will always be positive.
>
> - John
John Michl - 08 Dec 2005 21:23 GMT
Thanks Bob. I guess I'm dyslexic today.
Diana A. - 05 Mar 2008 17:35 GMT
> 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!