Dashes in phone numbers

[Bob_Irvine]

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?

[#2]

@Bob_Irvine 

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.

[#3]

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.