A data type that contains decimal numbers scaled by a power of 10. For zero-scaled numbers, that is, numbers with no decimal places, the range is +/-79,228,162,514,264,337,593,543,950,335
. For numbers with 28 decimal places the range is +/-7.9228162514264337593543950335
. The smallest non-zero number that can be represented as a Decimal is 0.0000000000000000000000000001
.
Note that at this time the Decimal data type can only be used within a Variant. You cannot declare a variable to be of type Decimal. You can, however, create a Variant whose subtype is Decimal using the CDec function. See data type summary.