Excel: Custom Validation Formula

I need to create a custom formula for a validation test with the requirement being 4 digits and a value within the range of 1000 and 6900. This could be simply accomplished by using whole number range and specifying the values, as it would be impossible to have an entry that was not 4 digits using whole numbers only. The requirements however specifically require a custom formula, which I have been trying and failing with for the past hour and a half. PLEASE HELP!!

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of June 11, 2017.

For more resources for Microsoft Excel