Data Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In excel I want to validate a cell where no more than 14 digits should be
entered. And I want another cell to be validated to be entered as text only
and any number should be restricted?

Please help me with this. Not sure how to do it.

Thanks
 
Select cell1 and DV>Allow>Whole Number 0 to 14

Select cell2 and Allow>Custom =ISTEXT(cell2)

Where cell2 is your cell reference like A1

Note: this does not prevent someone entering a number preceded by an apostrophe
which Excel thinks is text.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If formula and Data Validation parallely 1
custom validation with number & text 3
data validation for a single text entry 8
custom data validation on cells with data validation values 2
Need help with Data Validation Formula for a set of numerical andtext-based values 7
How do I get a Data validation list to select another validation l 1
Excel 2007-programming macros that apply to data validation 1
How to use formula to decide when to apply TIME data validation 3

Back
Top