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.
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?
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?
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.
They want to see "good news" as a positive where my formulas are showing them
as negatives.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
