Display -123.40 as (123.40) - Parenthesis around negative numbers
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