hi
currency data type will only handle up to 4 decimal while double data type
has a floating decimal(will handle more decimals). both are 64 bit (8 bytes).

in vb help look up data type summary, double data type and currency data
type for more details.


Regards
FSt1

"Gustaf" wrote:

I've inherited a project from another VBA developer. It deals a lot with cost (price) calculations, but I notice that the original developer has used Double for prices, rather than Currency. I've read that Currency should be used for money, but I'm not sure if and why it would matter in this project. The figures are up to 1 billion, and a precision of 6 decimals is enough. Maybe Double can handle that just as well as Currency? Wondering if I would gain anything by using Currency in this case.

Gustaf