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 DVAllowWhole Number 0 to 14

Select cell2 and AllowCustom =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

On Thu, 19 Apr 2007 12:54:04 -0700, Liz wrote:

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