View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Reverse + and - signs

Multiply by -1.

You can do this in place by using Paste Special, as in:

Enter -1 into a cell.
Copy it.
Highlight the range you want to change.
Use EditPaste Special...Multiply

Regards,
Fred

"C" wrote in message
...
I have a sheet that I need to show my negatives as positives and vice
versa.
Is there a function that can perform this for me?