Add Leading Zeros

[tsweep]

I would like to format an amount field with leading zeros and remove the decimal but keep the 2 digit cents.  I would also like to have trailing spaces for a text field.  Does anyone know how to accomplish this?  I've tried several things like right('0000000000' + [Amount],12).

[adik]

just format the measure in the list/crosstab, in the formatting options select Number, there you will find No. of Decimal Places, Minimum No. of Digits and Padding Character