Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

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