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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Format Cell and Data Validation 4
Need 7 digit number with differnt number of leading zeros 10
Numbers to sort as text 5
Extracting 7 digit number from alphanumeric string 10
Help with troublesome .CSV fields! 3
Finding matching numbers from 1 worksheet in another and with a tw 1
Numbers in a column won't add up 1

Top