Convert positive # to negative
 

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


--
bgn2
------------------------------------------------------------------------
bgn2's Profile: http://www.excelforum.com/member.php...o&userid=25774
View this thread: http://www.excelforum.com/showthread...hreadid=401361

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

bgn2 wrote:

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