View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rockbear Rockbear is offline
external usenet poster
 
Posts: 59
Default How to change all cells from minus to plus and plus to minus

Hi all, I have Excel 2007
How can I change from -to plus in a worksheet

The cells have now negative and I want all to be positive, how to do it?

eks :
A1 A2 A3 A4
-214 683 -384 454
want to change to
A1 A2 A3 A4
214 -683 384 -454
--
Just a regular user :)