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

Maybe:
=len(a1)



SHIRA wrote:

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

--

Dave Peterson

this was simple :)

"Dave Peterson" wrote:

Maybe:
=len(a1)



SHIRA wrote:

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

--

Dave Peterson

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

You can use this formula. It counts the number of digits for the number in
cell A1. Note that it counts the number of digits entered, not the number of
digits displayed. for instance if the number is formatted to show 2 decimals
and the number 5 is enetered, the cell will show 5.00, but since only 1 digit
was entered the formula will return 1...

=IF(ISERROR(FIND(".",A1)), LEN(ABS(A1)), LEN(ABS(A1))-1)

also I assume you don't count the decimal as a digit, nor the negative sign.
--
HTH...

Jim Thomlinson


"SHIRA" wrote:

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