The value returned by Val depends on the regional settings of Windows 95. For example, Val("1.23aB") returns 1,23 if the regional settings are such that the decimal character is comma, not the period. Now, in this case, Val(Val("1.23aB") will return 1 only. How can one take care of this situation. Using CDbl or the like won't help, since these work only in cases like CDbl("1.23") and not CDbl("1.23aB"), etc.
Can the regional settings be bypassed or changed from the Visual Basic program. If yes, then how?