Problem: When using the ActiveX connector with different locales, numbers are truncated
When I use the ActiveX connector with different locales, numbers are truncated.
You are using the ActiveX connector with locales that have different decimal separators like "."(periods) or ","(commas).
The Cdbl() function is capable of handling different decimal separators for different locales; if the correct decimal separator is not used, the numbers might get truncated and lead to undesirable results.
Solution or Workaround
While using whole numbers inside the Cdbl() function, the decimal separator should conform to the decimal separator of the locale.