HomeMicrosoft OfficeExcelRestrict Data to Number or Decimal in Microsoft Excel

Restrict Data to Number or Decimal in Microsoft Excel

This post is about how to restrict data in the cells in a worksheet to a number or decimal in Microsoft Excel.

How Restrict Data in a Cell to Number in Microsoft Excel ?

Microsoft Excel provides an option to limit the entry of data in the cells to a number.

You can do this through the following steps:

  • Select the range of cells where the limitations should be applied.
  • Click on the Data tab.
  • A dialog box appears and in the Allow drop-down, Click the Whole number.
  • Mention the minimum and maximum according to the option selected in the data dropdown.
Restrict Data to Number or Decimal in Microsoft Excel
  • Switch to the Input Message tab and specify the message that you want to display when the user hovers over the selected cells.
Restrict Data to Number or Decimal in Microsoft Excel
  • Click OK.

Now the cells accept only whole numbers in that range of cells and show error for other types of values.

Restrict Data to Number or Decimal in Microsoft Excel
Restrict Data to Number or Decimal in Microsoft Excel

How to Restrict Data in Cell to Decimal in Microsoft Excel?

Microsoft Excel provides an option to limit the entry of data in the cells to a decimal number.

To do so follow the below steps:

  • Select the range of cells where the limitations should be applied.
  • Click on the Data tab.
  • Select Data Validation from the Data Tools group.
  • A dialog box appears and in the Allow drop-down, Click the Decimal number.
  • Mention the minimum and maximum according to the option selected in the data dropdown.
Restrict Data to Number or Decimal in Microsoft Excel
  • Switch to the Input Message tab and specify the message that you want to display when the user hovers over the selected cells.
Restrict Data to Number or Decimal in Microsoft Excel

– Click OK.

Now the cells accept only decimal numbers in that range of cells and show error for other types of values.

Restrict Data to Number or Decimal in Microsoft Excel
Restrict Data to Number or Decimal in Microsoft Excel

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