Excell 2002

[Guest]

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

 

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

 

[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

 

[Dave Peterson]

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

It looks like the Greek letter Sigma.