serial number

drag-driver · Apr 16th, 2002, 11:14 AM

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 · Apr 16th, 2002, 11:18 AM

Quote:

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/viewtop...c=5253&forum=2

Chris Davison · Apr 16th, 2002, 03:05 PM

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. · Apr 16th, 2002, 03:06 PM

=LEN(123456)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 11:14 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	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.

Apr 16th, 2002, 03:05 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ]

Apr 16th, 2002, 03:06 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=LEN(123456)