| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative Sum
How do you make a negative sum show up in Parenthesis and red?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative Sum
Format the cell:
FormatCellsNumber In the Category list choose Number (or another appropriate format) On the right side of the dialog box is a set of choices, including how you want your negative numbers to appear. Click the one showing parens and red. Hope that helps. -- ERR229 "charmoll" wrote: How do you make a negative sum show up in Parenthesis and red? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| irritating warning for negative data on log charts | Charts and Charting in Excel | |||
| NPV Calc appears incorrect with a large # of negative cash flows | Excel Worksheet Functions | |||
| Negative Values Only | Excel Discussion (Misc queries) | |||
| Summing negative time | Excel Discussion (Misc queries) | |||
Hybrid Mode
