Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Conditional Formatting New Rule with Formulas in Excel
  • Filter Data Based on Date in Excel
  • Move chart to a separate worksheet in Excel
  • Conditional Formatting Icon Sets Examples in Excel
  • How to do a t-Test in Excel?

References

  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Count rows with at least n matching values
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Two-column Lookup in Excel
  • Convert text string to valid reference in Excel using Indirect function

Data Validations

  • Excel Data validation only dates between
  • How To Create Drop-down List in Excel
  • Excel Data validation number multiple 100
  • Excel Data validation allow weekday only
  • Excel Data validation allow uppercase only

Excel Data validation allow numbers only

by

This tutorial shows how to create Data validation to allow numbers only in Excel using the example below;

Formula

=ISNUMBER(A1)

Explanation

Note: Excel has several built-in data validation rules for numbers. This page explains how to create a your own validation rule based on a custom formula.

To allow only numbers in a cell, you can use data validation with a custom formula based on the ISNUMBER function.

In the example shown, the data validation applied to C5:C9 is:

=ISNUMBER(C5)

How this formula works

Data validation rules are triggered when a user adds or changes a cell value.

The ISNUMBER function returns TRUE when a value is numeric and FALSE if not. As a result, all numeric input will pass validation.

Be aware that numeric input includes dates and times, whole numbers, and decimal values.

Note:  Cell references in data validation formulas are relative to the upper left cell in the range selected when the validation rule is defined, in this case C5.

Post navigation

Previous Post:

COSH function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Data validation require unique number

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • How to use IFS function in Excel
  • How to use Excel NOT Function
  • IF, AND, OR and NOT Functions Examples in Excel

Date Time

  • Convert decimal minutes to Excel time
  • How to calculate future date say 6 months ahead in Excel
  • Two ways to sum time over 30 minutes in Excel
  • Display Date is same month in Excel
  • Convert decimal seconds to Excel time

Grouping

  • Group times into unequal buckets in Excel
  • Categorize text with keywords in Excel
  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • Group arbitrary text values in Excel

General

  • With vs Without Array Formula in Excel
  • How to create dynamic named range with INDEX in Excel
  • How to Create Calendar in Excel
  • 44 Practical Excel IF function Examples
  • How to calculate total from percentage in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning