Forum Discussion

u156531's avatar
u156531
Brass Contributor
Nov 10, 2023

Force a format on data input in a list column.

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

 

Thanks

SharePoint Online
  • Sigi7's avatar
    Sigi7
    Brass Contributor
    Nov 13, 2023

    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

Resources