View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lisbern lisbern is offline
external usenet poster
 
Posts: 1
Default change 2000 cells (negative numbers) into positive numbers

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?