Data Validation

[mlindquist]

Is there a way to do data validation to prevent text entry in a cell without using a macro? We also want to be able to copy data into the spreadsheet with the data validation.

 

[JoeMo]

Is there a way to do data validation to prevent text entry in a cell without using a macro? We also want to be able to copy data into the spreadsheet with the data validation.

Data Validation can be done w/o a macro by using the menu: Data>Data Tools>Data Validation to restrict manual entries to validated cells to the values you permit. However, this will not work for entries that are copied and then pasted to the validated cells. The latter scenario will require a macro solution.

 

[Gerald Higgins]

Hi, welcome to the board.

Yes, there are ways of doing this.

Here's one way . . .
Data Validation
Settings
Allow
Custom
Formula
=isnumber(a1)

This will allow you to type numbers into a1, but not text values.
Note, data validation does NOT stop you pasting invalid entries into the cell - in this example you could still paste a text string into the cell.