Entry Alert
Sunday, August 15th, 2010Entry Alert
affmage source=”ebay” results=”100″]Entry Alert[/affmage]
affmage source=”ebay” results=”50″]Entry Alert[/affmage]
Help Specifying Data Entry Rules in Excel?
Hi!
I need a cell to only accept 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?
Try this one,
- Go to Data
- Data Validation
- Select “Custom”
- Copy-paste the following formula
=(OR(ISTEXT(IFERROR(RIGHT (G1,1)*1,RIGHT (G1,1))),IFERROR((RIGHT (G1,1)*1),1)=0))*(ISNUMBER(LEFT (G1,8)*1))
- Type whatever the error message you want it to display when there is an error.
(i have put some spaces next to every RIGHT & LEFT function so you could see the whole thing. so first copy it to a cell & remove those spaces for it to work)
Entry Alert