Keep Decimals Out of the Equation with Data Validations in Excel

Data Validations in Excel

Using Data Validations in Excel can be very helpful, as validations make sure the data is entered correctly, and ensures all the intended functionality works according to plan. One possible validation scenario is the need for all numbers to be displayed as whole numbers. Follow these steps to ensure no decimals are included during data entry:

  1. Once your Excel workbook is open, drag-select the cells in which you want the numbers to be restricted to whole numbers.Data Validations in Excel - Select columns
  2. Click the Data tab on the ribbon, then in the Data Tools group, click the Data Validation command.Data Validations in Excel - Data Tools
  3. When the Data Validation dialog box appears, set the Allow section to Whole Numbers, the Data section to Greater than or Equal to, and the Minimum section to 0.Data Validations in Excel - Select Validation
  4. Once completed, click OK, and those cells will be restricted to whole numbers.
Want to learn more ways to make Excel work harder for you? Take a class from Mission Critical Training, in Denver and Phoenix.