View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default change positive to negative and viceversa

And then clean up that cell with the -1.

andresg1975 wrote:

how can i change positive values to negative values, and negative values to
positive values.
for ex:

column I

row 5 150 to -150

row 7 200 to -200

row 9 -30 to 30

and so on


--

Dave Peterson