Format data with input mask

I need data to be inputted following a certain format. In Microsoft Access I can create an input mask so regarless how data is entered, it will automatically update to the right format.

Example, if data is entered as EAC0145678945, then it will change to EAC-01-456-78945. does not support input mask and I haven’t found a formula that works.


This might get you started:

IF(REGEXMATCH({Data}, "^.............$"), REGEXREPLACE({Data}, "(...)(..)(...)(.....)", "$1-$2-$3-$4"), {Data})

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas: the SECRET Functions

Yes that works, but unfortunately it creates the data in a separate field. I wanted the data to format in the original field. But thanks!