Question

Locked

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

By gaminescholer ·
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?

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Use A Conditional Formula

by BFilmFan In reply to How do I format a cell to ...

See http://office.microsoft.com/en-us/excel/HP052510121033.aspx

Collapse -

Try this

by unhappyuser In reply to How do I format a cell to ...

If you always want ten characters, use Data Validation (under the Data Ribbon) for the length and try using formatting cells\Custom to set up the proper mask.
Check out this link: http://www.web-articles.info/e/a/title/Data-Validation-in-Excel-2007/


EMD

Collapse -

Mask Dilemma

by gaminescholer In reply to Try this

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....

Collapse -

How about this link?

by unhappyuser In reply to Mask Dilemma

http://www.web-articles.info/e/a/title/Data-Validation-in-Excel-2007/

EMD

Collapse -

Try this!

by unhappyuser In reply to How do I format a cell to ...

Once you clean it up I think it will work. Good luck!

http://www.ozgrid.com/forum/showthread.php?t=28913

EMD

Back to Desktop Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums