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