Hi there,
What is difference between decimal and double data types?

__________________
Please excuse me for poor and bad English.

I take it that you looked up the Data Types in the VBA help and that you would like to know the practical difference. In my experience, numbers of Double type sometimes don't evaluate to zero when one would expect, like This example doesn't show an error, I presume, but Double is capable of returning a non-zero result at the end of a zero-sum calculation. I haven't had a similar experience with Decimal and prefer to use it on principle ever since, which is a long time so that some of the details of the reasons have been forgotten.

Hi there,

Take a look at the table on page 143, chapter 5, where both data types are discussed. Also, Google knows a lot more about this:

http://www.google.nl/#sclient=psy-ab...double+decimal

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

The Decimal, Double, and Float variable types are different in the way that they store the values. Precision is the main difference where float is a single precision (32 bit) floating point data type, double is a double precision (64 bit) floating point data type and decimal is a 128-bit floating point data type.

Float - 32 bit (7 digits)

Double - 64 bit (15-16 digits)

Decimal - 128 bit (28-29 significant digits)

More about...Difference between decimal and double

Kerry