C
C
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?
Is there a function that can perform this for me?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Fred Smith
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 Edit>Paste Special...>Multiply
Regards,
Fred
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 Edit>Paste Special...>Multiply
Regards,
Fred
F
FSt1
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
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
R
Rick Rothstein \(MVP - VB\)
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
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
R
RagDyeR
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!
=====================================================
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?
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!
=====================================================
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
C
Thank you
C
C
Thanks!
FSt1 said: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
C
Thanks!
Fred Smith said: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 Edit>Paste Special...>Multiply
Regards,
Fred
C
C
They want to see "good news" as a positive where my formulas are showing them
as negatives.
as negatives.