Syntax |
Val(string_expression) |
Description |
Converts a given string expression to a number. |
Comments |
The number parameter can contain any of the following: Leading minus sign (for nonhex or octal numbers only) Hexadecimal number in the format &Hhexdigits Octal number in the format &Ooctaldigits Floating-point number, which can contain a decimal point and an optional exponent |
|
Spaces, tabs, and line feeds are ignored. If number does not contain a number, then 0 is returned. |
|
The Val function continues to read characters from the string up to the first nonnumeric character. The Val function always returns a double-precision floating-point value. This value is forced to the data type of the assigned variable. |
Example |
This example inputs a number string from an InputBox and converts it to a number variable. Sub Main() |
|
'The following table shows valid strings and their numeric equivalents: ' "1 2 3" 123 ' "12.3" 12.3 ' "&HFFFF" -1 ' "&O77" 63 ' "12.345E-02" .12345 |
See Also |
V |