In my case its ok that the trailing zeros get truncated. So this transform function works great for me.

Thanks everybody for your input.

Paul

>>Use transform() instead (without a format code). It won't truncate or round the number.
>>
>>>Is there a way to determine the # of decimal places in a number. I need to export data from tables. Once I know that the field is numeric I need to know how many decimal places there are for the str() command.
>>>
>
>Peter,
>I was thinking along those same lines but transform() does truncate trailing zeros when a format string is not specified. So if your field is N(6,4) and you have a value in it of 8.2500, transform will return 8.25.