07-26-2020 01:39 PM
Is there a way to automatically insert dashes when I'm entering phone numbers, ie 50228975278 that would automatically become 502-897-5278 instead of having to type the dashes?
07-26-2020 02:52 PM
You may apply to the cells standard phone number format as
and to modify it, if necessary, in Custom menu.
To apply select range with cells, Ctrl+1 and as above.
07-26-2020 02:54 PM - edited 07-26-2020 02:55 PM
If you open the format cells dialog box and select the special category, Excel has a built-in format option for phone numbers. If you prefer a dash as opposed to parentheses for the area code, select the phone number format and then click on the "custom" category and you can modify that format to remove the parentheses in lieu of a dash.