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