Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

how do i display negative numbers like in excel

niraj asked on April 13, 2018

for example I might want a negative number with parenthesis (212,33.12)
or I might want it with a negative sign -212,313.12
or I might want it in red etc 
i’m interested in the common excel variations

1 answer

Public
Dmytro Zvazhii Flexmonster April 16, 2018

Hello Niraj,
Thank you for your question. We recommend trying our customizeCell feature – https://www.flexmonster.com/api/customizecell/. It is a really powerful tool for changing pivot’s view. Here is an example of how it can be used – http://jsfiddle.net/flexmonster/cc2kyzfe/.
Please let us know if it works for you.
Regards,
Dmytro

Please login or Register to Submit Answer