expression(required; String or Char)
Any string representation of a number
A Double able to hold the number contained in
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")
&H (the octal
and hexadecimal prefixes) are recognized by the
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
Val removes spaces, tabs, and line-feed
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.