Converting positive numbers to negative numbers.
Posted by Erania Pruitt on December 10, 2001 1:48 PM
Could you give me a formula or macro that will allow me to convert positive numbers to negative numbers and vice verse.
Posted by Juan Pablo G. on December 10, 2001 1:50 PM
=-A1
Posted by Malc on December 10, 2001 2:03 PM
Copy a cell caontaining -1 Then select your range of numbers to have the sign changed then paste special values multiply
