Function that converts an expression into a Double (Number.)
Syntax CDbl (expression)
The Double data type stores precision floating point numbers from -1.79769313486232E308 to -4.94065645841247E-324 for negative values or 1.79769313486232E308 to 4.94065645841247E-324 for positive values.
CDbl cannot handle Null values, use Nz() to convert Nulls to a valid number.
Dim dblDemo as Double
dblDemo = CDbl(12 * 0.000001)
“People have a peculiar pleasure in making converts, that is, in causing others to enjoy what they enjoy, thus finding their own likeness represented and reflected back to them” ~ Johann Wolfgang von Goethe
CBool - Convert to boolean
CByte - Convert to byte
CCur - Convert to currency (number)
CDate - Convert to Date
CDec - Convert to Decimal (number)
CInt - Convert to Integer (number)
CLng - Convert to Long (number)
Number Data Types
Convert to Base 36
Nz - Detect a NULL value or Zero Length string.