Positive to Negative

L

Lori F

All,

Anyone know a way to convert positive numnbers to
negative? Admin asst has a spreadsheet with a range of
positives that she wants to make negative (all raw data,
no formulas in selected range), without retyping.

I appreciate the assistance.

Lori
 
P

Paul B

Lori, put -1 in a cell, copy it then select your data then edit, paste
special, check multiply
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
L

Lori F

Paul,

I can't believe I didn't think of that one (banging my
head against a wall). Thank you so much - worked like a
charm.

Lori
 
P

Paul B

Lori, your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 

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
Subtracting positive amts from negative and positive from positive 3
summing only positive or negative values 2
Negative value to positive 13
Problem with formula for finding last greater than/less than or equal to value 2
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 9
Converting positive numbers to negative numbers 4
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10

Top