2 Replies Latest reply on Jun 9, 2015 6:07 AM by Stu412

    Display -123.40 as (123.40) - Parenthesis around negative numbers

    Stu412

      Title

      Display -123.40 as (123.40) - Parenthesis around negative numbers

      Post

      Hi there

      The title says it all really, I just need a custom format for brackets around negative numbers.  They're sat on my data table as -1234.56.  I have found plenty of options for telephone number formatting which use left or right calculations etc, but nothing for this which surprises me.

      Any help gratefully received

      Thanks