Counting digit

izzyq · Apr 15th, 2002, 03:33 PM

Is there a function that will allow me to count the number of digits in a cell. I've found the "len" funtion that will count the number of characters for text, but nothing for a number.

Peter99 · Apr 16th, 2002, 04:43 PM

the LEN function should work for both alpha or numeric strings and indeed for an alpha-numeric string

typing 1234 or 1111 in Cell A1 and the formula =len(A1) in cell B1 should give you the result of 4

If it doesnt, check you have the latest Service release updates

anno · Apr 16th, 2002, 05:51 PM

?
http://www.mrexcel.com/board/viewtop...c=5253&forum=2

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

Apr 15th, 2002, 03:33 PM	#1
izzyq New Member Join Date: Mar 2002 Location: Calgary Posts: 20	Is there a function that will allow me to count the number of digits in a cell. I've found the "len" funtion that will count the number of characters for text, but nothing for a number.

Apr 16th, 2002, 04:43 PM	#2
Peter99 New Member Join Date: Mar 2002 Posts: 7	the LEN function should work for both alpha or numeric strings and indeed for an alpha-numeric string typing 1234 or 1111 in Cell A1 and the formula =len(A1) in cell B1 should give you the result of 4 If it doesnt, check you have the latest Service release updates

Apr 16th, 2002, 05:51 PM	#3
anno Board Regular Join Date: Feb 2002 Posts: 202	? http://www.mrexcel.com/board/viewtop...c=5253&forum=2