change 2000 cells (negative numbers) into positive numbers
lisbern wrote...
I have a colum of 2000 numbers (negative) and I would like to have them all
positive. I know I can multiple each number by -1 so it will be positive
(ex: -25 *-1=25) but I do not want to have to do *-1 to each cell, cell
by cell. Is there a way that I can change the sign in one shut?
Are they number constants? If so, Edit Replace, replacing - with
nothing.
|