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.


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

In the Formula box enter the following formula


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

Click OK.


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.