serial number

[drag-driver]

I have a number and i want to count the number of digits which are present in the number.
ie
123456 iwant to count how many digits their is ie in this case their is 6.

 

[Brian from Maui]

On 2002-04-16 10:14, drag-driver wrote:
I have a number and i want to count the number of digits which are present in the number.
ie
123456 iwant to count how many digits their is ie in this case their is 6.

http://www.mrexcel.com/board/viewtopic.php?topic=5253&forum=2

 

[Chris Davison]

if it's always a number with no decimals, try :

=IF(ISNUMBER(a1),LEN(a1))

(where a1 houses my example number)



_________________
Hope this helps,
Chris

This message was edited by Chris Davison on 2002-04-16 14:06

 

[Mark W.]

=LEN(123456)