Convert positive # to negative

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
 
G

Govind

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
 
Top