View Single Post
  #2  
Old March 15th, 2011, 11:27 PM
tarquinious tarquinious is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Mar 2011
Posts: 34
Default

Quote:
Originally Posted by Lourie View Post
I need to change a positive value to become negative value in Excel 2007 and then move the value two cells to the left. This I need to do selectively and repeatedly in a spreadsheet. I create a macro to do this but it does not work as it should.
In the cell 2 columns to the left you could type in the formula:
=-D2
...(assuming D2 is where the number is) and copy & paste this down, but if you want it to be selective, I'll need a bit more info on what the criteria is to be of any more use to you.