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()
a$ = InputBox("Enter anything containing a number","Enter Number")
b# = Val(a$)
MsgBox "The value is: " & b#
End Sub
|
|
'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
|
CDbl (function); Str, Str$ (functions).
|