CDbl

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.

Example

Dim dblDemo
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

Related:

CBool - Convert to boolean.
CByte
- Convert to byte.
CCur
- Convert to currency (number).
CDate
- Convert to Date.
CInt - Convert to Integer (number).
CLng
- Convert to Long (number).
Convert to Base 36
Syntax - IsBlank function to detect Empty or NULL or Zero.


 
Copyright © 1999-2021 SS64.com
Some rights reserved