AnsweredAssumed Answered

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

Question asked by Stu412 on Jun 9, 2015
Latest reply on Jun 9, 2015 by 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

 

Outcomes