Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
9541moosegirl - 08 Dec 2005 16:26 GMT
Please help!
David Billigmeier - 08 Dec 2005 16:35 GMT
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!
CLR - 08 Dec 2005 16:36 GMT
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!
Bob Phillips - 08 Dec 2005 16:40 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.