Home |
Search |
Today's Posts |
#1
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change positive numbers to negative numbers without re-ente | Excel Worksheet Functions | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Change series of numbers from positive to negative | Excel Discussion (Misc queries) | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
How do I change a column of 500 numbers from positive to negative | Excel Discussion (Misc queries) |