Select the cell, do datavalidation, under allow select custom and then use
this formula


=ISERROR(1*A1)


under error alert type in a message that will pop up if someone tries to
enter a number

It won't work if someone pastes in a value


--


Regards,


Peo Sjoblom

"how to make a cell require text" <how to make a cell require
wrote in message
...
i am makeing a worksheet and i need t know how to make a cell where it
requires a text input before it will allow you to go to another cell. I
have
questions on a sheet that i want to make have answers manditory before it
will let someone go on to the next question.