This Excel tutorial explains how to set up data validation to only allow an exact length characters to be entered in the cell in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, I want to set up a cell to only allow (EXACTLY) 10 characters. How can I do this?
B = Value is the TACO Class I Soil Component of the Groundwater Ingestion Exposure Route concentration (35 IAC 742.Appendix B, Tables A and B). C = Value is the TACO-defined Acceptable Detection Limit (ADL) for the chemical in soil. D = Value is the lowest TACO Class I concentration between column range 6.25 to 6.64 and column range. The Best Mac Antivirus Protection for 2020. Despite what you may have heard, your Apple computer is not immune to malware. We test the top contenders to identify those offering the best Mac.
Answer: Select the cells that you wish to restrict to a certain number of characters. In this example, we've selected cells A2 to A5.
Select the Data tab in the toolbar at the top of the screen. Then in the Data Tools group, click on the Data Validation drop-down and select Data Validation.
When the Data Validation window appears, set up your criteria. In this example, we've setup the cells to allow a text length equal to 10.
Next, click on the Error Alert tab.
Mac Value Guide
Enter an Error message to appear when data entered does not conform to the validation rules.
Best Value Mac
Now if a value is entered in one of those cells that is NOT equal to 10 characters, the following error message will appear: