Rounding down

[Champak]

Nothing big, but I want to round down no matter what the number is after the decimal point. As it is, I'm just stripping everything after the decimal, but I would prefer coding a little tighter and I believe I can get it within stringformat but I don't know how. Here is what I've tried so far, but only the third is giving me what I want.

MsgBox(0,0,StringFormat( "%.0f",123.63576875665))
MsgBox(0,0,Round(123.63576875665))


MsgBox(0,0,StringLeft(123.63576875665,StringInStr(123.63576875665,".")-1))

Edited June 12, 2008 by Champak

[sandin]

int() ?

[Champak]

Thanks.

[smashly]

Floor()

[Champak]

Ceiling() and Floor()...never noticed those before, thanks.