| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I show text and numbers in data validation? i.e. L1234
I want people that use my spreadsheet to HAVE to enter a letter followed by
three numbers. I usually use data validation for tasks like this, however, I can't figure out have to enforce a custom format of "letter, number, number, number". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbers show instead of text | New Users to Excel | |||
| Data Validation Drop Down List - Always Show | Excel Discussion (Misc queries) | |||
| Show do I share a dynamic list for data validation? | Excel Discussion (Misc queries) | |||
| Data Validation using whole numbers from formulas | Excel Discussion (Misc queries) | |||
| Show comma in data validation list? | Excel Discussion (Misc queries) | |||
Threaded Mode
