|
| 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
March 16th, 2010, 03:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change numbers from positive to negative.
not sure if there is an easy way to do this other than physically rekeying
the number. is there a formula or something for me to use to change a number from being positive to negative? example: 262.00 change to -262.00 or vice versa change from negative to positive. thanks 
|
|
#2
March 16th, 2010, 03:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to change numbers from positive to negative.
--Enter -1 in a cell. Copy the cell
--Keeping the copy select the number range --Right clickPasteSpecialselect 'Multiply' and click OK -- Jacob "tammy p" wrote: not sure if there is an easy way to do this other than physically rekeying the number. is there a formula or something for me to use to change a number from being positive to negative? example: 262.00 change to -262.00 or vice versa change from negative to positive. thanks
|
|
#3
March 16th, 2010, 03:15 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to change numbers from positive to negative.
You can simply do:
=-A2 to reverse the sign of any number, or if you want all positive numbers: =ABS(A2) all negative numbers: =-ABS(A2) -- Best Regards, Luke M "tammy p" wrote in message ... not sure if there is an easy way to do this other than physically rekeying the number. is there a formula or something for me to use to change a number from being positive to negative? example: 262.00 change to -262.00 or vice versa change from negative to positive. thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
