View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lhaen lhaen is offline
external usenet poster
 
Posts: 1
Default 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".