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