You will have to be careful with that:

Sub test()

Dim d As Double

d = 100
MsgBox Len(d)

End Sub

May have to do:
MsgBox Len(CStr(d))


RBS


"Dave Peterson" wrote in message
...
Maybe:
=len(a1)



SHIRA wrote:

does anyoone know if there is a function that count the number of digit
in a
number?

--

Dave Peterson