Truncate or Trunc()

[emreut]

How do I truncate a decimal number in a VBA code? Currently I am using MOD to overcome this problem but it is a pain and takes too many lines of code to do a simple task. There must be something to use instead. All I need is to cut out the decimal part of a number and use the whole number part.

Thanks in advance,
Emre

 

[chrismcbride]

Try Int() or Fix()

 

[emreut]

Int () works great!

Thanks