View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jaleel Jaleel is offline
external usenet poster
 
Posts: 187
Default CHANGE POSITIVES VALUES TO NEGATIVES

Hi

Cut your data from your actual column, select a cell in a helper column,
Paste it. Now copy your data from the helper column, select the cell in your
actual colum, Paste Special - "Subtract".

Jaleel



"andresg1975" wrote:

I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I
ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP.