change cell from negative to positive

G

Guest

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 a positive number to negative 16
Help with positive and negative numbers 1
Cause formulae totals to reflect negative and positive amount inpu 7
Change negative nmbr to positive 7
Excel VBA to match positive and negative transactions 3
Coloring cells 8
Reallocate array cells value from positive to negative 0
Columns negative to positive 2

Top