ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   turning a negative into a positive (https://www.excelbanter.com/excel-programming/350724-turning-negative-into-positive.html)

childothe1980s

turning a negative into a positive
 
Hello:

If you have a column of negative numbers, is there an easy way of changing
them all at one time into positive numbers without having to take away the
minus sign to each number individually?

Thanks!

childofthe1980s

Ken Johnson

turning a negative into a positive
 
Hi childofthe1980s
In any spare cell type -1 then copy that cell, then select the column
of negative numbers, then go Edit, Paste Special and select the
Multiply operation, then click OK.
Ken Johnson



All times are GMT +1. The time now is 07:01 AM.

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