In this article we will learn how to restrict cell entries to text only in Microsoft Excel 2010.
While working on reports, you may want to prevent the users from entering any value other than text. To prevent users from entering numbers in a cell, we will use Excel’s built in feature Data Validation.
Let us take an example:
In column A, we want to ensure that only text can be entered into the cells.To prevent the users from entering numbers in column A.
Using Excel’s built in feature Data Validation, we can make customized reports for the end user to enter the information that we are looking for.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.