• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Help - Show value in parenthesis?

edro

edro

Lifer
Lets say Cell B1 value is: =sum(A1:A3)
Normally it will display: 4
I want B1 to display: (4)

All I want is the value that is shown, to have parenthesis around it.

I see that you can have currency and numbers with negative values, shown with "( )" around them, but these numbers are not negative or currency.

Is these some kind of formatting that can allow this?

Thank you!
 
Sure. Just go to Format Cells and choose the Custom category in the Number tab. In the edit box enter a format such as "(0)" (no quotes). That will do it.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top