Hi,

I have VBa function which takes a varibale (integer); is it possible to extract number digits of this variable..

when I use Len function in VBA, it is returning wrong results:

For example for

123 has 3 digits

1234 has 4 digits

123456 has 6 digits

1234567 has 7 digits

[VBA]

Public Function Calc(ByVal AccountNo As Long) As String

Dim Len_accountNo As Integer

Len_accountNo = Len(AccountNo)

Calc = Len_accountNo

End Function

[/VBA]

Will be thankful for any response...