View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default How to change positive numbers to negative numbers without re-ente

You could also use the formula abs(A1) which is the absolute value of
A1 and will always be positive.

- John