Count number of digits (Numbers)

's Computer Specifications

Hi, I am after a formula that can tell me that a string of numbers doesnt
equal to six digits if that makes any sense. Reason: Each cell is picking up
numbers from other cells, but if the total number of digits doesnt equal to
six (maybe more or less), its an error. Data Validation isnt any good for me
in this instance. Any help greatly appreciated. John

's Computer Specifications

Hi,

=LEN(A1)<=6

Mike

"JohnUK" wrote:

> Hi, I am after a formula that can tell me that a string of numbers doesnt
> equal to six digits if that makes any sense. Reason: Each cell is picking up
> numbers from other cells, but if the total number of digits doesnt equal to
> six (maybe more or less), its an error. Data Validation isnt any good for me
> in this instance. Any help greatly appreciated. John

's Computer Specifications

Fantastic - Thank you very much Mike
Regards
John

"Mike H" wrote:

> Hi,
>
> =LEN(A1)<=6
>
> Mike
>
> "JohnUK" wrote:
>
> > Hi, I am after a formula that can tell me that a string of numbers doesnt
> > equal to six digits if that makes any sense. Reason: Each cell is picking up
> > numbers from other cells, but if the total number of digits doesnt equal to
> > six (maybe more or less), its an error. Data Validation isnt any good for me
> > in this instance. Any help greatly appreciated. John

's Computer Specifications

=LEN(A1)<> 6 would be TRUE if there are more or less than 6 digits and FALSE
if the length is 6.

"JohnUK" wrote:

> Hi, I am after a formula that can tell me that a string of numbers doesnt
> equal to six digits if that makes any sense. Reason: Each cell is picking up
> numbers from other cells, but if the total number of digits doesnt equal to
> six (maybe more or less), its an error. Data Validation isnt any good for me
> in this instance. Any help greatly appreciated. John

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count number of digits in a cell	=?Utf-8?B?SnVsaWVlZWVl?=	Microsoft Excel Worksheet Functions	6	15th Nov 2006 04:55 PM
urgent : count of digits in a number	=?Utf-8?B?U0hJUkE=?=	Microsoft Excel Programming	4	26th Apr 2006 09:19 PM
I need to count the digits of a number	Jimmy	Microsoft Access Queries	1	9th Feb 2004 10:16 AM
I need to count the digits of a number	Jimmy	Microsoft Access Getting Started	1	9th Feb 2004 10:16 AM
Need a formula to count the number of digits in a number.	=?Utf-8?B?SkVUSFdB?=	Microsoft Excel Worksheet Functions	2	24th Jan 2004 06:01 AM