How can I restrict a cell(s) to alpha-only data entry?
 

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.

How can I restrict a cell(s) to alpha-only data entry?
 

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.

How can I restrict a cell(s) to alpha-only data entry?
 

Select A1:A10 and DataValidationAllowCustom

In dialog box enter =ISTEXT(A1)

A2:A10 will also be given the DV

Watch out that Excel doesn't add $ signs to the cellref.


Gord Dibben MS Excel MVP

On Wed, 10 Jan 2007 09:32:01 -0800, Robert T <Robert
wrote:

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.