I have data that gives me several totals. I need to change the signs of value for each number. So if the number is positive I need it to be negative and if the number is negative I need it to be positive. Is there a function available that I can use to achieve this. Or any other work around? Below is an example of what I am looking for.
What I Have: What I need
| TOTAL | Total Reversed |
|---|
| 17,819,123.87- | 17,819,123.87 |
| 32,220.36- | 32,220.36 |
| 18,465,712.39 | 18,465,712.39- |
| 7,597.36 | 7,597.36- |
Thank you!
Melissa
