Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to interchange positive to negative value in excel
I have lot of data in one column. some are positive & negative value. I have
interchange to positive to negative & negative to positive. RKS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to interchange positive to negative value in excel
In a separate cell, enter -1. Copy that cell
Select all the other cells to change EditPasteSpecial Click Multiply OK Clear the cell with -1 in. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "RKS" wrote in message ... I have lot of data in one column. some are positive & negative value. I have interchange to positive to negative & negative to positive. RKS |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to interchange positive to negative value in excel
Take an empty cell and type "-1"
Copy Edit-- Paste Special -- click on the button "Multiply" and say ok The numbers would have got converted. Check if this works "RKS" wrote: I have lot of data in one column. some are positive & negative value. I have interchange to positive to negative & negative to positive. RKS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
calculating positive and negative formulas | Excel Worksheet Functions | |||
change cell from negative to positive | Excel Discussion (Misc queries) | |||
Automatically put negative sign in cells with positive numeric dat | Excel Discussion (Misc queries) |