Excell 2002
 

How does one change the sign of a negative number, that is, from (-100) to
100 within a cell or column or row without doing it manually? Also is there a
shortcut key for the SUM function?

Thanks!!

Custom format of #,##0;#,##0

There is a Signa button on the formatting toolbar.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Coyote Joe" <Coyote wrote in message
...
How does one change the sign of a negative number, that is, from (-100) to
100 within a cell or column or row without doing it manually? Also is
there a
shortcut key for the SUM function?

Thanks!!

put -1 in an empty cell.
copy that cell
select your range to change
edit|paste special|check the multiply button
clean up that cell where you added the -1



Coyote Joe wrote:

How does one change the sign of a negative number, that is, from (-100) to
100 within a cell or column or row without doing it manually? Also is there a
shortcut key for the SUM function?

Thanks!!

--

Dave Peterson

And there's an icon on Standard toolbar that may help you.

It looks like the Greek letter Sigma.



Coyote Joe wrote:

How does one change the sign of a negative number, that is, from (-100) to
100 within a cell or column or row without doing it manually? Also is there a
shortcut key for the SUM function?

Thanks!!

--

Dave Peterson