expression(required; Numeric or String)
The range of
-2,147,483,648 to 2,147,483,647; fractions are
expression cast as an Integer
expression to an Integer; any
fractional portion of
expression must evaluate to a numeric
value; otherwise, a type-mismatch error is generated.
If the value of
expression is outside the
range of the Integer data type, an overflow error is generated.
When the fractional part of
exactly .5, CInt always rounds it to the nearest
even number. For example, .5 rounds to 0, and 1.5 rounds to 2.
Dim iMyNumber as Integer If IsNumeric(sMyNumber) then iMyNumber = CInt(sMyNumber) End If
When converting a string representation of a number to a numeric data
type, you should use the data type conversion functions — such as
CInt — instead of Val,
because the data type conversion functions take into account the
system’s regional settings. In particular,
CInt recognizes the thousands separator if
it’s present in
Val does not. For example, if
expression is 1,234, then
CInt successfully converts it to the integer
value 1234, while Val converts it to 1.
Use IsNumeric to test whether
expression evaluates to a number before
performing the conversion.
CInt differs from the Fix and Int functions, which truncate, rather than round, the fractional part of ...