Data Validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Liz - 19 Apr 2007 20:54 GMT

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

Reply to this Message

Gord Dibben - 19 Apr 2007 21:48 GMT

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

>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
[quoted text clipped - 3 lines]
>
>Thanks

Reply to this Message

Rate this thread: