How do I change numbers from positive to negitive
Is there a way to change number with a cell range from positive to negative
other than multipling it by -1 |
You can make the multiply very easy. Put -1 in an un-used cell. Select the
cell and copy it. Then go to the cells you want to invert and paste special with the multiply box checked. All the cells will be inverted. -- Gary''s Student "Debi" wrote: Is there a way to change number with a cell range from positive to negative other than multipling it by -1 |
you can format the cells you want changed to negative, go to custom and type in "-0" -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=475092 |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com