![]() |
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 |
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