Selecting The Input Type of an Alphanumeric Cell
There are 5 types of alphanumeric cells from which to choose that control the content that is placed in the input cell.
-
Select the cell you want to modify.
-
On the Home tab, click Cell, and then click Alphanumeric.
- In the input type box, select the type.
|
If you choose |
The cell |
|
Unrestricted |
Accepts any alphanumeric value. |
|
Postal |
Only accepts a postal code. In accordance with postal code format, the letters in the postal code are automatically capitalized. |
|
Yes/No |
Only accepts a Y or N value. |
|
X Only |
Only accepts an X value. |
|
Zip code |
Only accepts a zip code. |
Related Topics