ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Convert positive # to negative (https://www.excelbanter.com/excel-discussion-misc-queries/43597-convert-positive-negative.html)

bgn2

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


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

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




All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com