Since both decimal as double are numeric types, I doubt that there is
any difference, as in from what they can convert, but there is big
difference in types to which they convert to.
As you may know TypeOf Decimal IsNot TypeOf Double. Decimal is a base 10
floating point number, while Double is a base 2 floating point number. They
have different precisions & ranges.
If you have Option Strict On (you do have Option Strict On don't you)
attempting to use CDbl and assign it to a Decimal will cause a compile
error. While attempting to use CDec and assign it to a Double will cause an
implicit conversion from Decimal to Double (read it will work, but you
really did CDbl(CDec(?)).
The short of it is a Decimal number can exactly represent base 10 (ergo
Decimal) numbers. Double (and Single) cannot exactly represent base 10
numbers, as they store the numbers as base 2.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.