Try using 'Custom' and the formula
=ISTEXT(A1)
where A1 is the cell you apply the validation to,
Regards,
Alan.
"Robert T" <Robert wrote in message
...
I'm preparing a worksheet and need to have a range of cells to allow
alpha-only data entry, the validation option is not working for me unless
I'm
missing something.