division

[leonepaolo]

Hi!

I'm sure this is real easy.

When I divide two numbers, or have a decimal number, I only want the digits to the left of the decimal. Aside from:

Left(MyDecimalNumber, InStr(1, MyDecimalNumber, ".")

is there a more mathematical way of doing this?

Please note that I'm not looking to round the number.

Thanks in advance,
Paolo.

 

[guitarzan]

Look at the Int() function.

 

[Ed2020]

Or use integer division - use the backslash instead of forward slash:

10/3 = 3.33333333333333
10\3 = 3

Ed Metcalfe

Please do not feed the trolls.....

 

[leonepaolo]

Thank you very much.