Reverse + and - signs
Thanks!
"Fred Smith" wrote:
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?
|