View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yanick Yanick is offline
external usenet poster
 
Posts: 28
Default Reverse the signs of values

Use the function ABS()

It will return the positive value of a cell
--
Yanick


"DianeG" wrote:

Is it possible to reverse all the signs in a worsksheet ie from negative to
positive in one go?

Thanks

diane