Phone with/without area code format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Phone field is text without input mask.
If we type 7 digits, I want it to display as ( ) xxx-xxxx
If we type 10 digits, I want it to display as (xxx) xxx-xxxx
 
There are no input masks in Excel, try this custom format

[<=9999999]"( ) "###-####;(###) ###-####
 
Back
Top