ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   converting positive numbers to negative numbers (https://www.excelbanter.com/excel-discussion-misc-queries/218419-converting-positive-numbers-negative-numbers.html)

dmantzaaa

converting positive numbers to negative numbers
 
Hello
Is there a way to select a group of cells that are currently positive and
change them to negatives? Thanks

Elkar

converting positive numbers to negative numbers
 
Enter a -1 into any unused cell
Copy that cell
Select your range of numbers to convert
From the Edit Menu, choose "Paste Special"
Check the "Multiply" option
Click OK
Delete the -1 you entered at the beginning

HTH
Elkar


"dmantzaaa" wrote:

Hello
Is there a way to select a group of cells that are currently positive and
change them to negatives? Thanks



All times are GMT +1. The time now is 05:43 AM.

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