MS Excel Number only Validation

Smoke Studios

#Excel #DataValidation #ExcelTips  In this tutorial, we’ll learn how to set up Number Only Validation in Microsoft Excel. This feature ensures that users can enter only numbers into specific cells, preventing text, symbols, or invalid data. It’s an essential way to maintain data accuracy and consistency in your spreadsheets.

Transcript

00:00If you want to do number only validation in a particular cell, you need to go ahead and select

00:05it. Then go around over here onto data and then go to data validation. And over here in the

00:11validation criteria, you need to go ahead and expand it and select custom right here. And then

00:17in formula, you need to type in this equals, and then you need to type in is number right here,

00:23just like this. Open up the bracket, press A1 right here as the reference cell and press OK.

00:29So once you do that, if I would type in any number, it'll accept it. But if I were to type in any

00:34letter, it says the value doesn't match. You need to retry and then go ahead and type in a number

00:39again. You can simply click and drag this out right here, just like this, to copy out the validation

00:45just like this, as you can see, just like this as well.

Category

Transcript

Be the first to comment

Recommended