| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom format
I need a custom format that puts a number in parentheses whether it is
positive or not. I cannot treat the cell as a text cell and just enter the parentheses manually, because I need to use the number from this cell in a computation. It appears that all of the custom formats provided (listed under the "Number" tab of the "Format Cells" dialog box) only apply parentheses if the number is negative. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom accounting format | Excel Discussion (Misc queries) | |||
| hiding % characted in the Y axis using custom format | Charts and Charting in Excel | |||
| Custom Format for User Defined Function | Excel Discussion (Misc queries) | |||
| adding custom format | Excel Discussion (Misc queries) | |||
| Custom percent format needed | Excel Worksheet Functions | |||
Threaded Mode
