Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
875
Can you format negative values like Excel?
posted

In Excel, there is an option to format and display negative numbers in parentheses and red (with no negative sign showing) .  Is is possible to format negative numbers in the grid the same way?

I can change the color to red in the InitializeRow even by testing the values and changing the cell appearance.  If I change the number to a string, I can have the parentheses, but then I have to strip out the parens and convert when trying to get the value.

Parents
No Data
Reply
  • 0
    Offline posted

    Consolidate information with the Ampersand image (and) · Select the cell where you need to put the joined information. · Type = and select the principal cell you need to join. This is how 0 in front of numbers comes along side.

Children
No Data