Count number of digits (Numbers)

J

JohnUK

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
 
A

AnotherNewGuy

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