|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 8th, 2005, 04:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change positive numbers to negative numbers without re-ente
Please help!
|
|
#2
December 8th, 2005, 04:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!
|
|
#3
December 8th, 2005, 04:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!
|
|
#4
December 8th, 2005, 04:40 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!
|
|
#5
December 8th, 2005, 05:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#6
December 8th, 2005, 06:01 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#7
December 8th, 2005, 09:23 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to change positive numbers to negative numbers without re-ente
Thanks Bob. I guess I'm dyslexic today.
|
|
#8
April 1st, 2006, 10:16 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!
|
|
#9
March 5th, 2008, 05:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to change a list of possitive numbers to negative | michelle | Worksheet Functions | 0 | November 16th, 2005 08:25 AM |
| I Need a formula to evaluate a cell with + or - values | Bob in Oklahoma | Worksheet Functions | 6 | October 31st, 2005 02:41 PM |
| How do I change numbers from positive to negitive | Debi | Worksheet Functions | 2 | October 11th, 2005 06:09 PM |
| How to change a series of positive numbers to negative numbers | Ellie | Worksheet Functions | 5 | September 5th, 2005 05:10 PM |
| Descending sort with positive numbers before negative ? | OrdrupAB | General Discussion | 1 | February 19th, 2005 09:28 AM |
Linear Mode
