Val Function |
Microsoft.VisualBasic.Conversion
Val( expression )
Any string representation of a number
A Double able to hold the number contained in expression
Converts a string representation of a number into a Double
The Val function starts reading the string with the leftmost character and stops at the first character that it does not recognize as being part of a valid number. For example, the statement:
iNumber = Val("1A1")
returns 1.
&O and &H (the octal and hexadecimal prefixes) are recognized by the Val function.
Currency symbols, such as $ and , and delimiters, such as commas, are not recognized as numbers by the Val function.
The Val function only recognizes the period (.) as a decimal delimiter .
Prior to processing expression , Val removes spaces, tabs, and line-feed characters .
If you are developing an international application, you should use the more modern, internationally aware CDbl function to convert strings to numbers, since CDbl can recognize all decimal separators.