cell contents - 10 digits or greater

[ajm]

I am trying to force my users into giving me data in a certain format. this particular cell needs to be atleast 10 numbers long, or if its greater than 10, the eleventh must be "/" followed by a last single numeric. for example: 1234567891 or 1234567899/1

 

[ajm]

Are the "rules" I summarized in that other post correct?

yes. thats why i can't figure out the problem. i got sidetracked last night (sick wife and kids) and didn't get any further than i had yesterday. i had pulled apart the formula and was focussing on the mid statement within. it seemed to be where the problem arose.

 

[T. Valko]

yes. thats why i can't figure out the problem. i got sidetracked last night (sick wife and kids) and didn't get any further than i had yesterday. i had pulled apart the formula and was focussing on the mid statement within. it seemed to be where the problem arose.

All that MID is doing is testing to see if the 11th character is the slash / character (if there is an 11th character).

 

[T. Valko]

Isn't "Length must be 10 characters" redundant if "The number must be >=4000000000 and <=9999999999"

Yeah, I guess it is.

No, it isn't !

I just remembered why I set a length condition.

I think the OP only wants integers so:

4000000000.1

Would meet the condition of being >=4000000000 and <=9999999999 but would not be a valid integer entry so I included the length test. Could've also used INT but I chose the length test.

 

[ajm]

sorry, i was laboring under the misapprehension that the mid statement, instead of checking to make sure the "/" was the 11th character, actually changed the 11th character to the "/". so, if a user types in 4123456789/4, it works just fine. thanks you for your help on this one. ajm

 

[T. Valko]

sorry, i was laboring under the misapprehension that the mid statement, instead of checking to make sure the "/" was the 11th character, actually changed the 11th character to the "/". so, if a user types in 4123456789/4, it works just fine. thanks you for your help on this one. ajm

You're welcome. Thanks for the feedback!