>>Hi everybody,
>>
>>If we have these numbers
>>123000
>>130000
>>140400
>>
>>and we need 123, 13, 1404 (e.g. remove the trailing zeros), can we do it without loop? I don't see a way after thinking 3 minutes on the problem.
>>
>>Thanks in advance.
>
>If x = 123000
>y= INT( VAL( STRTRAN( STR( x), "0", "")
>
>Jeez, Naomi, don't go bursting any blood vessels in your brain thinking on this for more than 3 minutes! :-)

You certanly didn't use your brain on this one. :)