Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excell 2002
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!! |
#2
|
|||
|
|||
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 wrote in message ... 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!! |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
Spreadsheet conversion (Quattro Pro to Excel 2002) | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) | |||
EXCELL 2002 Glitch???? | Excel Discussion (Misc queries) |