Changing positive to negative over a range

A

AB

I have a large range of figures in a column that are positive that I
need to change to negative figures. Any quick way of doing this?
 
L

Leo Heuser

1. Enter -1 (negative one) in a cell, e.g. H34
2. Select H34 and copy it (<Ctrl>c for instance)
3. Select the range of figures.
4. Choose Edit > Paste special and choose "Multiply" OK.
5. <Esc> (to cancel the selection)

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
A

Anon

AB said:
I have a large range of figures in a column that are positive that I
need to change to negative figures. Any quick way of doing this?
Click to expand...

Put the number -1 in a spare cell and copy it.
Select your numbers and use
Edit > Paste Special > Operation, multiply.
(The -1 can now be deleted.)
 
P

Paul Corrado

AB,

In a blank cell place a -1

Edit\Copy that cell

and then highlight the range you wish to change and

Edit|Paste Special and select the multiply option.

PC
 

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

Program buttons to create a word document 0
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
SUMIF with broken range 10
Possible to Combine reports to's to a single box? 0
How to change numbers from positive to negative. 2
Subtracting positive amts from negative and positive from positive 3
HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN 5
Change positive to negative number 3

Top