I want to input mobile number in Text field after saving the record the mobile number should display in (999) 999-9999 format..I've tried creating a formula field of text and gave the below formulaSUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( Phone__c , '.', NULL), ' ', NULL), '-', NULL), ')', NULL), '(', NULL)But it doesn't worked for me.Can anyone help me doing this..
i will suggent that you can write a validation rule on text field and using regex check the format of input and force user to enter phone number in required formate