It works. Thanks.
>Hi Don,
>
>Try this:
>
>
>TRIM(TRIM(PADL(MyNumericField,16),0,"0"),0,".")
>
>
>>I think there is a way to do this but I'm not sure. Suppose you have a number field defined with 2 decimals. You want to print it in a report but truncate any trailing zeros (and the decimal point if both are zero). Is there a formatting technique that would do this?