>hi, I am trying to use format control to place a negative number in a parentheses but the output seems a little strange. For example, i have a -7810 store in a variable and have format @Z(9,999,999.99.
>
>It ouput shows ( 7,810) with empty spaces before the figure 7 instead of (7,810). Please advise what is the correct format to use in order to remove all the empty spaces.
>
>many thanks

TRANSFORM(7810,'@ZB9,999,999.99')