Set Character or Digits Limit in MS Excel Cells | Set Data Range | How to Limit Cell Value Entry.
Excel Tutorial: How to limit the values a user can enter into a cell.
When we make entries like telephone numbers of a country or area and pin or zip codes we wish to make a data entry of a specific size or length.
For example the telephone numbers can be only 10 digits or the zip codes may be exactly 6 characters or digits. Here we can make the data entry error free by limiting the data entry of the user. We describe in the video how to accomplish this using data validation and a user form. In the process we also learn many interesting facets of data validation and Excel.