ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Reverse + and - signs (https://www.excelbanter.com/excel-discussion-misc-queries/174284-reverse-signs.html)

C

Reverse + and - signs
 
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?

Fred Smith[_4_]

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?



FSt1

Reverse + and - signs
 
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?


Rick Rothstein \(MVP - VB\)

Reverse + and - signs
 
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?



RagDyeR

Reverse + and - signs
 
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?



C

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?




C

Reverse + and - signs
 
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?


C

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?




C

Reverse + and - signs
 
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?





All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com