I only wanted to give you a kick in the right direction. You must tell us the formula, we can not read your mind! What is the relation between the number and what you want to display?

>Dear Sir,
>
>I have test your following codes
>
>thisform.text2.value=TRANSFORM(thisform.text1.value,'@R =999,999,999/=')
>
>it shows following result
>
>= 9,,74,,18
>
>Please help again