CInt

Function that converts an expression into an integer value.

Syntax
      Cint (expression)

Fractional values will be rounded to create a whole integer number, Tie-breaking: If the fraction is less than or equal to .5, the result will round down.
If the fraction is greater than .5, the result will round up.

CInt cannot handle Null values, use Nz() to convert Nulls to a valid number.

Examples

Dim intDemo as Integer

intDemo = CInt(45.76)
>45

“A man is like a fraction whose numerator is what he is and whose denominator is what he thinks of himself. The larger the denominator, the smaller the fraction” ~ Leo Tolstoy

Related

CBool - Convert to boolean
CByte
- Convert to byte
CCur
- Convert to currency (number)
CDate
- Convert to Date
CDbl
- Convert to Double (number)
CDec
- Convert to Decimal (number)
CLng - Convert to Long (number)
Number Data Types
Convert to Base 36

Nz - Detect a NULL value or Zero Length string.


 
Copyright © 1999-2024 SS64.com
Some rights reserved