Force a format on data input in a list column.

[u156531]

How do I force the user to enter a text field in the format #####-#####. The # symbol represents a numeric.

Thanks

[#2]

@u156531 

Use column validation in column settings.

=AND(ISNUMBER(VALUE(LEFT(col;5)));ISNUMBER(VALUE(RIGHT(col;5)));MID(col;6;1)="-")

 works for me.

BR