Count number of digits (Numbers)
 

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

Count number of digits (Numbers)
 

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

Count number of digits (Numbers)
 

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

Count number of digits (Numbers)
 

=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