Forum Discussion
Format Negative Percent to Brackets/Parentheses
How do you format a negative percentage using parentheses (and not the - sign)?
Example: -3%
Want: (3%)
Use the custom format: 0%;(0%);0%
You can do this on the Modeling tab of the desktop.
- Select the modeling tab
- Select the field
- Change it to a decimal format, then Custom
- Enter the custom format above.
There is a more in depth article here about custom number formats.
3 Replies
- edhans
Community Champion
Use the custom format: 0%;(0%);0%
You can do this on the Modeling tab of the desktop.
- Select the modeling tab
- Select the field
- Change it to a decimal format, then Custom
- Enter the custom format above.
There is a more in depth article here about custom number formats.