Convert positive # to negative

  • Thread starter Thread starter bgn2
  • Start date Start date
B

bgn2

Hi,
I heard that there is a smart icon that lets you convert a range with
negative numbers to positive numbers and vice versa. Could someone
tell me how to do it?

Thanks for your help.

Regards,
BGN2
 
Hi,

Am not aware of this icon, but you can type -1 in any cell, copy that
cell, select the range you need and choose Edit->Paste Special and
choose 'Multiply' in the Operation.

Regards

Govind
 

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

Red cell for negative numbers in Excel 1
How to convert positive figures to negative ones? 11
Excel 2002 : Convert Positive Numbers to Negative Numbers ? 2
Changing formuals from Positive to negative 4
Excel VBA to match positive and negative transactions 3
Excel 2002 : Any fast way of converting positive to negative numbe 2
Help with positive and negative numbers 1
change a positive number to negative 16

Back
Top