Question Locked

How do I format a cell to accept only data that meet specific requirements?

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need a cell to accept only data that meet the following criteria:
1. the first 9 characters should be composed of numbers only
2. the 10th character should either be a letter or the number zero (0).

If they don't meet both of the requirements, I need for an alert box to pop up informing them of the requirement they failed to meet.

How do I do this?

6 replies

by gaminescholer

Hi, EMD!

I am able to limit the length of the characters with Data Validation and come up with an Alert Message. But I still have problems with the "proper mask".

Here's what I did:
Data Validation
Allow: Text Length
Data: Equal To
Length: 10

It limits the character length but that's about it. It doesn't distinguish between numbers and letters....

This discussion is closed to new replies.