Val

The Val function returns the numbers contained inside the given string as a numeric value of an appropriate type.

Syntax
Val(Value)
Return value
Type	Description
Variant	Numeric value of the passed variant
Parameter
Use	Name	Type	Passing	Description
Required	Value	Variant	ByVal	Wert zur Bestimmung des numerischen Wertes

Note

The Val function reads the characters of a string until the first character that cannot be interpreted as part of a number. Symbols and characters that are often recognized as part of a numeric value (e.g. currency symbols and commas) are not recognized. Spaces, tabs, and line feed characters are removed from the argument. The Val function recognizes only the point (.) as a valid decimal point.