Input Mask (Excel 2000 9.0.6926-SP-3)

Topic

New Reply

Is there a way to limit the data entry for a column to a certain format? The format is 10 numbers, a dash, a letter. For example, 1234567899-T could be an entry. Is this possible?

Thanks

Reply | Quote

Replies

Ass ume the cell is A1
Select A1
Data – validation
Allow: Custom
Formula:
=AND(NOT(ISERROR(VALUE(LEFT(A1,10)))),MID(A1,11,1)=”-“,CODE(RIGHT(UPPER(A1),1))>=65,CODE(RIGHT(UPPER(A1),1))<=90)

Steve

Reply | Quote