Syntax Dim result As Decimal = CDec(expression) expression (required; Numeric or String) Any expression in the valid range of the Decimal data type
Description The CDec function converts expression to the Decimal data type. Usage at a Glance An expression that evaluates outside the valid range of the target data type results in a runtime error. Nonnumeric expressions also generate an error. In most cases, the numeric conversion functions are a better choice than the Val function when converting a string, as the conversion functions take into account the system's regional settings. However, Val converts empty strings to zero without error. Use IsNumeric to test whether expression evaluates to a number. This function does not support named arguments.
Example Dim targetNumber As Decimal If IsNumeric(stringNumber) Then targetNumber = CDec(stringNumber) End If Version Differences The Decimal data type replaces the VB 6 Currency data type, and it is appropriate for high-precision numbers. See Also Val Function |