CDbl Function
Returns an expression that has been converted to a Variant of subtype
Double.
CDbl(expression)
The expression argument is any valid expression.
Remarks
In general, you can document your code using the subtype conversion functions
to show that the result of some operation should be expressed as a particular
data type rather than the default data type. For example, use CDbl or
CSng to force double-precision or single-precision arithmetic in cases
where currency or integer arithmetic normally would occur.
Use the CDbl function to provide internationally aware conversions
from any other data type to a Double subtype. For example, different
decimal separators and thousands separators are properly recognized depending on
the locale setting of your system.
This example uses the CDbl function to convert an expression to a
Double. Dim MyCurr, MyDouble
MyCurr = CCur(234.456784) ' MyCurr is a Currency (234.4567).
MyDouble = CDbl(MyCurr * 8.2 * 0.01) ' Convert result to a Double (19.2254576).
|