>>hi,
>>thank you for reply,it works
>>>
>>>lnNumber = 1235.789
>>>lcText = TRANSFORM(INT(lnNumber % 1 * 1000))
>>>
>>>>
>
>Are you sure you always have 3 digits after the point? If you have 2 or more than 3, you would not get the decimal only part, e.g. test with
>
>lnNumber = 344.8990034
>
>and with lnNumber = 23.44
>
For an undertermined number of decimal digits use
GETWORDNUM(TRANSFORM(lnnumber),2,'.')
However, this yeilds an empty string (rather than 0) if there are no decimal digits
>What exactly is the goal here?