Displaying the integer part of a number: uses the Fix function, which returns the integer portion of a value - the value without any decimal digits : Fix « Math Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Math Functions
  3. Fix

Displaying the integer part of a number: uses the Fix function, which returns the integer portion of a value - the value without any decimal digits

 
Sub GetIntegerPart()
    Dim MyValue As Double
    Dim IntValue As Integer
    MyValue = 123.456
    IntValue = Fix(MyValue)
    MsgBox IntValue
End Sub








Related examples in the same category

1.Fix() Returns the integer portion of a number.
2.Fix(number) returns The integer portion of number (without rounding). If number is negative, returns the negative number greater than or equal to number.
3.Fix(-3.14159) returns -3