Stop Text Being Input

If you want to stop text being entered in a range you can use a Custom Data Validation formula.

Select the range and press in sequence, not held down, Alt a v v. This opens the Data Validation dialog.

dv_shortcut

From the Allow drop down select Custom (last entry).

In the Formula box enter the following formula

=NOT(ISTEXT(A2))

Replace A2 with the top left cell in your range. Make sure there are no $ signs in the reference.

Click OK.

Not_Text


Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.