Excell 2002

C

Coyote Joe

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!!
 
B

Bob Phillips

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)
 
D

Dave Peterson

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
 
D

Dave Peterson

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

It looks like the Greek letter Sigma.
 
Top