View Single Post
  #1   Report Post  
ctdak
 
Posts: n/a
Default Automatically put negative sign in cells with positive numeric dat

I have many cells with positive numeric content that I need to change to
negative numbers without changing the absolute value of the numbers. Is
there a way to highlight a block of cells and have a negative sign inserted
in all of them? It will take me forever to do this manually.