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.
Comments