change cell from negative to positive

T

Terry

I am trying to change the polarity of a cell with a signal funtion, i.e.
change a negative number to a positive and visa versa. I have a spreadsheet
which I have imported from an accounting software and I need the numbers
which are positive to be negative and numbers which are negative to be
positive. I know that I can multiply the cell by a -1 but I have more than
1700 cells to do this to.
 
E

Earl Kiosterud

Terry,

If this is a one-time change, do this. Put -1 in a cell, select it, and
Copy. Now select the 1700 or so cells, Edit - Paste Special - Multiply.
 

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.

Ask a Question

Similar Threads

Change the colour of a neighbouring cell 6
Program buttons to create a word document 0
Negative value to positive 13
Cumulative formula for word table 0
XIRR Giving Negative Number on Positive Cash Flow Stream 11
Changing row background from external program 0
Add "+" plus symbol for a positive percentage 4
IF Statement accepting only positive values 1

Top