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 CInt
to force integer arithmetic in cases where single-precision, or double-precision arithmetic normally would occur.
Use the CLng
function to provide internationally aware conversions from any other data type to a 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.
function differs from the Int
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.