Excel - Allow only Text or only Numbers Entered into a Cell in Excel - Custom Formulas

This tutorial shows you how to limit the entry of data into a cell to only those characters that are numeric or contained within the alphabet. You will be presented with a complex and easily customizable formula that will allow you to determine what a user can enter into a cell, combined with data validation. This tutorial will cover the steps needed to customize the formula and anything else that is required to implement this into a spreadsheet in Excel.

[AnalyticsInDetails]

I searched more than 100 formulas but this one is the BEST.
Thank you....

[accord]

Thank you sir, i've been looking for this for a while, but there is a problem
The issue is i want all the cells in D column to type only alphabet but also to be a minimum of 3 letters and maximum of 10 letters in each cell not more or less.

If I use the formula you've showed in the video it does restrict to letters but will allow to type as much as they want?

Can you help me please if possible?

[shaunmoore]

Great tutorial...but how do I do the same thing with a range of cells or a group of cell ranges....I have tried a few way I thought would work, but I cannot get it to work properly....please help....

[TeachExcel]

The function =ISTEXT() allows for non-alphabetical characters to be input into a cell. And =ISNUMBER() also allow for characters that are not strictly numbers but which construct numbers, such as decimal points (periods). So, if you really want to limit the input to just text or number characters, you should use the formula in the tutorial or a similar formula. Plus, the formula in the video allows for a great deal of customization as far as which characters to allow.

[duckgoesquacklmao]

Could I use this with ImportHTML and how?

[TsiriniainaRakotonirina]

Thank you, thank you, thank you! This is the only one that works after more than 50links!

[realflickchick]

The formula doesn't allow for periods in decimal value numbers. I tried adding the period to the formula but it gave me the error because of the txt value (the period)

[Excel]

I have a question please how Separate figures from characters within the same cell by using functions

[lorddracula]

hi! how does it work if we've to enter some specific words? lets say words like "good" and "bad"

[thefinest]

How can we able to show "vowels" in any name we enter??

[imamhussain]

Dear Sir/Madam, Actually When I Type Suppose 5 Its Coming 0.5 Why Its Comingn Like That Can U Answer Me. Thank You

[TeachExcel]

Try something like this: /free-excel-macros/m-54, delete-text-from-cells.html at the teachexcel website. I can't put links here, you really need to go to the forum so you can get a more complete answer that could also include an attached worksheet with a working macro sample. But, try the macro above and see if that works.

[socalledvinoth]

how to allow the cell only text/numbers without show any error.
Ex;

if user type number in the text cell means it wont display

[waelalzahaykah]

Hello, how can i force the cell to take formulas only

[manishkdas]

What if I only want to allow dates, what condition should I enter???

[rrovers]

thanks for the form.
in my file I want to max of 8 charaters of a number.
how can this be added in the form

[SolidSmoke]

Just trying to add the numbers -0.50, -0.75 and excel keeps trying to turn that into a formula instead of just accepting it as text. =ISTEXT() and =ISNUMBER() both don't work.

[ajiinfor]

Sir i have problem, and until now cannot be solve. My problem is i have 2 input device keyboard and kaliper machine, and my boss told me, that user dont input number to cell in excel using keyboard, user must be using kaliper machine to input number on cell in excel document. How can i do that? Please 🙏

[cncrim]

Question: how about any whole number greater and equal to 0, and only allow letter X to be input?

[TeachExcel]

This is really much much easier to solve on the forum excelkey.com, where you can include a sample.