Prevent text entry in a number formatted column

Use Data Validation.

Select the cell that you want to control. Then in the Data tab select Data Validation.

Then in the Allow, select Custom and put the formula:

=ISNUMBER(A1)

Where A1 is the cell in which you are putting the Data Validation.

enter image description here

Now when they try to put 2+3 they will get an error.

enter image description here

And will have to change it to a number for it to be accepted.

Related