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". |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I show text and numbers in data validation? i.e. L1234
One way:
Allow: Custom Formula: =AND(LEN(A1)=4, CODE(UPPER(LEFT(A1,1)))=65, CODE(UPPER(LEFT(A1,1)))<=90, ISNUMBER(--RIGHT(A1,3))) In article , lhaen wrote: 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". |
Reply |
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) |