use len function on a decimal

[jcavigli]

I have a number say: 123.45. Len(123.45) = 5; I know this. However

I like to use the len function on the numbers before the decimal point only, so that: Len(123.45) = 3

How can this be done?

[VBA Noob]

Try

=LEN(INT(A1))

VBA Noob

[jcavigli]

works just great. thanks again