Reverse + and - signs
Thank you
"RagDyeR" wrote:
Multiply everything by -1.
Enter -1 in a cell.
Right click in that cell and choose "Copy".
Select the cells you wish to change.
Right click in that selection and choose "Paste Special".
Then, click on "Multiply", then <OK, then <Esc.
Clear the cell with the -1.
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"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?
|