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