Use of the Val function should be discouraged as far as I am concerned: it doesn't recognize International number formats.
The CFunctions (CInt, Clng, CDbl, ...) use the locale settings to do the conversion job, Val does not have this capability and therefore may not be able to recognize number formats that are used outside the US. _________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]