| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cell to accept 2 letters only
Hello column "F" is for states and I only want the abbriviation of each
state as follows 2 alpha charatects in upper case letters e.g. NY I formatted the column as text but how do I do the data validation for two 2 characters and upper case letters or is there and easier way? VBA? thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format a cell to accept sentences... using return key | Excel Discussion (Misc queries) | |||
| format a cell to accept a date or a whole number | Excel Discussion (Misc queries) | |||
| Format cell to accept only specific character-reject others | Excel Discussion (Misc queries) | |||
| cell format in Excel 2002 SP3 will not accept long numbers | Excel Worksheet Functions | |||
| How can I format a cell to accept feet and inches and add them | Excel Worksheet Functions | |||
Threaded Mode
