ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Reversing the sign of a number (https://www.excelbanter.com/excel-discussion-misc-queries/13066-reversing-sign-number.html)

Craig

Reversing the sign of a number
 
Is there a way to reverse the sign of a number or series of numbers.

Thanks,

Craig



Peo Sjoblom

You can put -1 in an empty cell, copy it, select the numbers you want to
"reverse" and do editpaste special and select multiply

--

Regards,

Peo Sjoblom


"Craig" wrote in message
...
Is there a way to reverse the sign of a number or series of numbers.

Thanks,

Craig






All times are GMT +1. The time now is 08:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com