Excell 2002

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

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


"Coyote Joe" <Coyote Joe@discussions.microsoft.com> wrote in message
news:F8674778-FD6A-42E1-9682-74CB43189D6C@microsoft.com...
> 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]

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

[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