The conversion functions can be used e.g. if you want some operation result to be expressed as a particular data type (rather than the default data type). For example, use
CDbl or
CSng to force double-precision or single-precision arithmetic in cases where integer arithmetic normally would occur.
Use the
CSng function to provide internationally aware conversions from any other data type to a value of the
Single type. For example, different decimal separators and thousands separators are properly recognized depending on the locale setting of Windows system.
If expression lies outside the acceptable range of the
Single type, then an error occurs.
Caution: This function can convert only values with separators set locally (e.g. value 3.14 or 3,14). Therefore a problem arises when values in the text form originate on another computer with different setting. That's why it is recommended the
Pm.CSng method that solves this problem!