HomeMicrosoft OfficeExcelHow to limit entries to numeric value in Microsoft Excel ?

How to limit entries to numeric value in Microsoft Excel ?

There are times when you might want to control what data the user can enter to a cell. For example , you want the user to enter only a numeric value that is greater than 75.

How to limit entries to numeric value in Microsoft Excel ?

You can do this easily in Excel using the Data Validation.

1. Open your workbook in Microsoft Excel and select the range of cells that you want to limit to the numeric value greater than 75.

2. Click Data Tab and then choose –> Data Validation –> Data Validation

image

3. In the Data Validation dialog , select the “Settings” tab and then select the following and then click OK button.

“Whole number” in the “Allow” drop-down list.

“greater than or equal to” from the Data drop-down list.

Enter the value 75 from the Minimum value.

SNAGHTML81724e

Now , try entering invalid values in the selected columns , you should see a error message displayed to the user stating “This value doesn’t match the data validation restrictions defined for this cell”.

image

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021