View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default 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.