Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Negative number format

Does anybody know if there's a way to make all negative numbers in parenthesis and give them a red color for the whole document, instead of manually doing it for every chart? In other words, can I do this in the script? Thank you!

2 Replies
crusader_
Partner - Specialist
Partner - Specialist

Hi,

To give color to values is not possible I suppose. Especially when you work with aggregation in charts.

Regards,

Andrei

sunny_talwar

For parenthesis you can go to document properties (Ctrl + Alt + D) and go to Number tab and drag on all the field names and use give it whatever format you want to give it. For instance $#,##0.00;($#,##0.00) (Negative Number dollar number will be with parenthesis)

Hope this helps.

Best,

S