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 of the operation). For example, use
CInt or
CLng functions to force integer arithmetic in cases where single-precision, or double-precision arithmetic normally would occur.
Use the
CLng function to provide internationally aware conversion from any other data type to the value of the
Long type. For example, different decimal separators are properly recognized depending on the locale setting of Windows system, as are different thousand separators.
Note: CLng function differs from the
Int and
Fix functions, which truncate, rather than round, the fractional part of a number. If the fractional part is exactly 0.5, then the
CLng function always rounds it to the nearest even number. For example, 0.5 rounds to 0, and 1.5 rounds to 2.