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
 
Back
Top