How to Validate Only Numbers in Cell in Excel Office 365?
Tags: validateonlynumbersi, excelpreface
Published: 2021-03-17 09:16:08

---
title: How to Validate Only Numbers in Cell in Excel Office 365?
published: true
date: 2021-03-17 09:13:58 UTC
tags: Validateonlynumbersi,ExcelPreface
canonical_url: https://geekexcel.com/how-to-validate-only-numbers-in-cell-in-excel-office-365/
---

Today, we are going to see how to **validate only numbers in a cell in Excel Office 365**. We can easily do this task by using the [Data Validation](https://geekexcel.com/excel-office-365-data-validation-options/) option in Excel. Let’s get into this article, and learn the instructions to achieve this task. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Validate Only Numbers in a Cell:

If you want to validate only numbers in a cell or a selected range in Excel, do as follows.

- Firstly, you need to **select the cell or a range of cells** that you want to allow only the numbers.
- For instance, in the below screenshot, we have selected a range **B2:B6**.

![Select the range](https://geekexcel.com/wp-content/uploads/2021/03/1.png)<figcaption id="caption-attachment-22509">Select the range</figcaption>

- Then, you need to **select** the **Data Validation** option under the **Data tab.**

![Data Tab](https://geekexcel.com/wp-content/uploads/2020/12/2-15.png)<figcaption id="caption-attachment-19337">Data Tab</figcaption>

- It will open the **Data Validation Dialog Box** where you need to **click** the **Settings** tab.
- You have to **select** the **Custom** option under the **Allow drop-down**  **list**.
- In the Formula box, you have to **enter** the below-given **formula** and **select** the **input range** using the browse button.

**=[ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)(input range)**

![Data Validation Dialog Box](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_hZcwEzIrCt.png)<figcaption id="caption-attachment-22510">Data Validation Dialog Box</figcaption>

- Now, you need to **hit** the **OK** button.
- Then, you can **enter the input numbers** in the range.

![Enter numbers](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_yLQXnDhucN.png)<figcaption id="caption-attachment-22511">Enter numbers</figcaption>

- If you enter any invalid data, then it will display a warning message as shown in the below figure.

![Enter a string value](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_HG0SCjLfMd.png)<figcaption id="caption-attachment-22512">Enter a string value</figcaption>

## Summary:

In the above article, we have described the simple instructions to **validate only numbers in a cell in Excel Office 365**. Leave your **suggestions/feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)**

#### Read Also:

- [Excel Office 365 Data Validation Options!!](https://geekexcel.com/excel-office-365-data-validation-options/)
- [How to Rename Multiple Files using Macros (VBA) in Excel 365?](https://geekexcel.com/how-to-rename-multiple-files-using-macros-vba-in-excel-365/)
- [Excel Formulas Group Numbers with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-group-numbers-with-vlookup-function/)
- [Formulas to Lookup Two Tables with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-lookup-two-tables-with-vlookup-function/)
- [Excel Formulas to Group the Arbitrary Text Values ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-group-the-arbitrary-text-values/)