In Excel, how can a range of Pos #'s be changed to negative num

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I dulicate a large series of cells that are all positive. Is there a
shortcut to change them to all negaive?
 
Hi,

Type -1 in a cell, copy that and then select the range, which has the
positive numbers which you want to convert to negative.

Right click on the range, select paste special, and choose action as
'Muliply'.

Regards

Govind.
 
You must log in or register to reply here.

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

How do you convert 100- to -100 in excel? 3
Question about conditional formatting of zeros in Excel 0
Trouble flagging conditions in Excel using VB 6
How do I convert a column of numbers from positive to negative? 3
converting positive numbers to negative numbers 1
directing a total to various cells dependent of its value 1
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
Sorting pos. & neg. numbers in a cell 1

Back
Top