| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Checking & Forcing Data Entry in Cells | Excel Discussion (Misc queries) | |||
| Can a standard data entry form be used to change formats of cells? | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Hybrid Mode
