>Hi, sorry i may have confused you. What i want is to have negative numeric value enclosed in parentheses instead of showing as - sign. I tried the function @( and it works but I can't get rid of the empty spaces within the parentheses.
>Let say i have -7810 and format '@Z(9,999,99.99', it shows (....7810) instead of (7810). What i to have the parenthese nicely enclosed the number.
>
>Note: ..... denote empty spaces in the above example.
>
>thanks
It seem like Transform does not behave exactly according to help. Try this

x=-7810
?Chrtran(Transform(x,'@Z(9,999,999.99'),' ','')