Positive to Negative

  • Thread starter Thread starter Lori F
  • Start date Start date
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
 
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 **
 
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
 
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 **
 
Back
Top