cdbl(Convert to a double)

MS Excel: CDBL Function (VBA)

In Microsoft Excel, the CDBL function converts a value to a double.

Syntax

The syntax for the CDBL function is:

CDbl( expression )

expression is the value to convert to a double.

Applies To

• Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Function

• VBA function (VBA)

VBA Function Example

The CDBL function can only be used in VBA code. For example:

Dim LDouble As Double

LDouble = CDbl(8.45 * 0.005 * 0.01)

The variable called LDouble would now contain the value of 0.0004225.