>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! :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.