Force a format on data input in a list column.

Brass Contributor

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

 

Thanks

1 Reply

@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