Change Positive to Negative

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Any ideas on how to automatically change a column of
positive values into negative values? I have over 4,000
of them.
 
Hi
one way:
- enter '-1' in an empty cell
- copy this cell
- select your positive values
- goto 'Edit - Paste Special' and choose 'Multiply'
 
Automatically? Or just in one step?

if the latter, put -1 in an empty cell. Copy the cell. Select your
column. Choose Edit/Paste Special, selecting the Values and Multiply
radio buttons.
 

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

Subtracting positive amts from negative and positive from positive 3
Change positive to negative number 4
HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN 5
How to change numbers from positive to negative. 2
Reallocate array cells value from positive to negative 0
summing only positive or negative values 2
How to Show "+" for positive and "-" for negative 10
Counting consecutive negative value 7

Back
Top