Hi Ali,
The result returned by VAL() function isn't affected by SET DECIMAL setting. So, Val("89.335") will always return 89.335. The display of numeric values is affected by SET DECIMAL command.
>Hi Everybody,
>
>I want to calculate the numeric value of a string with any decimal points. The problem with
Val() is: I have to use
Set Decimal To for a specific number of decimal points.
>
>For example.
>If
Set Decimal to 2>
Val(“89.335”) yields 8.34
>and if
Set Decimal to 2>
Val((“89.335”) yields 8.335
>
>Is there any solution?
>
>Thanks,
>Ali
--sb--