I'm trying to make error messages appear when someone tries to enter the wrong data type in a certain cell with data validation in Excel 2010. Is there a feature or some sort of formula I can use?
Ex. There is an error when someone tries to enter their name as a number, or id as a word.
Alex
. How would you enter your nameAlex
as a number? That just does not make sense. Your question does not make sense. Don't abuse the people who are trying to help you. Reflect and get your premises right. You need to define your outcomes a lot more clearly. "Enter names as a number" does not cut it. What do you need? Allow only alpha character? Allow only numeric characters? Allow letters and numbers but not symbols like +_)(*&^%$$# -- be specific. As it stands right now, nobody knows what you really need. Define it.