Data validation

[PatrickCarlsen]

Hi

Is it possible to create a custom data validation, so that one can only type in a value like "123456-7890"?

The point is that the ones typing information in the given cells can only type in 6 numbers followed by a dash and then followed by 4 numbers.

[#2 · Accepted solution]

I don't think you can restrict it to numbers, but a rule like this can do the general format: =NOT(ISERROR(MATCH("??????-????",A1,0)))

[#3]

Thanks a lot. That worked