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?

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?

hi
not a built in function. traditionally this is usually accomplished by
simple multipling by a negative one. say your number are in column A.
=A1*-1
if 5 were in A1, the formula would return -5, thus changing the sign of the
number from positive to negative and vice versa.

Regards
FSt1

"C" wrote:

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?

Do you mean for just the entries you have (making the assumption that all
future entries will be correctly signed) or do you mean something to correct
all future entries (because they will continue to be entered with the wrong
sign) or both?

Rick


"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?

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?

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?

Thanks!

"FSt1" wrote:

hi
not a built in function. traditionally this is usually accomplished by
simple multipling by a negative one. say your number are in column A.
=A1*-1
if 5 were in A1, the formula would return -5, thus changing the sign of the
number from positive to negative and vice versa.

Regards
FSt1

"C" wrote:

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?

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?

They want to see "good news" as a positive where my formulas are showing them
as negatives.

"Rick Rothstein (MVP - VB)" wrote:

Do you mean for just the entries you have (making the assumption that all
future entries will be correctly signed) or do you mean something to correct
all future entries (because they will continue to be entered with the wrong
sign) or both?

Rick


"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?