The variant has a special sub type called Decimal that can be used to hold very large numbers.
This data type must be declared as a Variant and can only be created using the CDec() conversion function.
More info Numbers > Fixed Point
This can support 29 significant figures with 28 decimal places.
Use this data type when you do not want rounding errors.
If you do not need this kind of precision you should always use the Double data type instead.
This data type uses 14 bytes
The default value is Empty because it must be declared as Variant
Dim MyDecimal As Variant
MyDecimal = CDec(3000000000000)
These are stored as 96 bit (12 byte) signed integers scaled by a variable power of 10.
The power of 10 scaling factor specifies the number of digits to the right of the decimal point and ranges from 0 to 28.
The smallest non zero value with 28 decimal places is:
+/- 0.0000000000 0000000000 000000001
The largest value with 28 decimal places is
+/- 7.9228162514 2643375935 43950335
This data type provides the greatest number of significant digits for a number.
This data type is the slowest of all the numeric data types.
This data type widens to Single or Double
You can convert Decimal to Single or Double without an Overflow error.
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext