DaTa VaLiDaTiOn

So here is one more feature of excel by which we write only text or numbers in the cell/column/row. We can do this by data validation in the data tab. And for entering the mobile number we can format the columns so that it can accept only 10 digits. After formatting according to text or numbers it can accept only that if we format according to number the cell will accept only numbers if we try to write any text it will reject it. Similarly in case of text it will reject numbers.

Text  

If we want to write only text in the columns there are some steps:

• Select the area in which you want only text.
• Then click data validation option in data tab.

• In data validation click on settings and you will see the validation criteria .
• From validation criteria allow custom.

• Then type formula =ISTEXT(Range in which we want text). Then press enter.

Now you can write only text in it if you try to write number it will reject it. If you want to clear this format then you can see in the above picture the option clear all. Click on it and press enter/ok. And all the format you apply with the help of data validation should be cleared.

NUMBERS

In case of numbers there are two cases whether to fix the limit of number or write only numbers in columns. Let’s start with first one the limit of numbers. Limit should be fixed mainly for phone numbers. So that we don’t enter the wrong mobile number. All we need to do is:

• Select the column in which we write mobile number
• Click on data validation in data tab.

• Now in settings select text length in validation criteria, and in data select equal to and in length type 10.
• Then press enter.

By mistake if you write less or more than 10 numbers it will reject it. So it helps to lower your mistakes.

Now the second aspect is to write only number in the column. for this we have to follow the below steps:

• Select the column in which you want to write only numbers
• Go on data tab and click data validation

• In the validation criteria select custom and in the formula type =ISNUMBER(Range of the column). And then press enter.