| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
percentage in brackets
I have input a formula that calculated the percentage increase (decrease)
from a figure in a particular year. If I format the cell as percentage, the negative (decrease) percentage has a minus sign. I would like the percentage to show up in brackets. Is there any way to input the formula yet still have the decrease show up in brackets? (I'm using Excel 2002) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentage in brackets
Format Custom as
0%;(0%) or of course 0.00%;(0.00%) -- Kind regards, Niek Otten Microsoft MVP - Excel "CIW" wrote in message ... I have input a formula that calculated the percentage increase (decrease) from a figure in a particular year. If I format the cell as percentage, the negative (decrease) percentage has a minus sign. I would like the percentage to show up in brackets. Is there any way to input the formula yet still have the decrease show up in brackets? (I'm using Excel 2002) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentage in brackets
FormatCellsNumber tabselect 'Number' and select the format from the list
'Negative Numbers' If this post helps click Yes --------------- Jacob Skaria "CIW" wrote: I have input a formula that calculated the percentage increase (decrease) from a figure in a particular year. If I format the cell as percentage, the negative (decrease) percentage has a minus sign. I would like the percentage to show up in brackets. Is there any way to input the formula yet still have the decrease show up in brackets? (I'm using Excel 2002) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you format a percentage in brackets (3.40%) vs. -3.40% | Excel Discussion (Misc queries) | |||
| when are [ ] brackets used | Excel Worksheet Functions | |||
| help with brackets | Excel Discussion (Misc queries) | |||
| =D6-E6 there are brackets? | Charts and Charting in Excel | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Linear Mode
