Chapter-2: Decimal Number Validation

We can put a validation in the Excel cells  for Decimal Number in the same way we did it for Whole Number.

Below are the steps to apply data validation for decimal number:

  • Select the range.
  • Go to Data tab>>Data Validation>>Click on Data Validation.
Data Validation Option
Data Validation Option
  • Below given window will be opened.
  • Select Decimal in Allow drop down.
  • Select between in Data drop down and put Minimum and Maximum value.
  • Click on OK button.
Data Validation for Decimal Number
Data Validation for Decimal Number

As we have given the minimum 3.00 and maximum 3.99 in the criteria. So decimal numbers between 3.00 to 3.99 will be allowed to enter. if any other value will be entered it will show “The value you entered is not valid

Error while entering wrong number
Error while entering wrong number

In Data Drop down below given items are available:

Items in Data drop down list
Items in Data drop down list
  • between: is used to allow the decimal number between given minimum and maximum criteria.
  • not between: is used to not allow the decimal number between given minimum and maximum criteria.
  • equal to: is used to allow only one decimal number which has been enter given in criteria.
  • not equal to: is used to not allow only one decimal number which has been given in criteria.
  • greater than: is used to allow all the decimal numbers which are greater than the number which has been given in criteria.
  • less than: is used to allow all the decimal numbers which are less than the number which has been given in criteria.
  • greater than or equal to:is used to allow all the decimal numbers which are greater or equal to the number which has been given in criteria.
  • less then or equal to: is used to allow all the decimal numbers which are less than or equal to the number which has been given in criteria.

Next ChapterPrevious Chapter