remove leading zeros with transform

[wjl11]

hello,____trying to wrap a positive number with parens and at the same time trim any spaces and zeros.____transform(GLNUMBER,"(999999.99)")__returns ( 123.45)____how do I get rid of the spaces?

[kfleming]

Why not just add the parentheses as literal text on the layout and format the numeric field as fixed and use autotrim to close the space instead of using transform?____Kathleen__R&R Support