Dashes in phone numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-1546813%22%20slang%3D%22en-US%22%3EDashes%20in%20phone%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546813%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20automatically%20insert%20dashes%20when%20I'm%20entering%20phone%20numbers%2C%20ie%2050228975278%20that%20would%20automatically%20become%20502-897-5278%20instead%20of%20having%20to%20type%20the%20dashes%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1546813%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546837%22%20slang%3D%22en-US%22%3ERe%3A%20Dashes%20in%20phone%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546837%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F583289%22%20target%3D%22_blank%22%3E%40Bob_Irvine%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20apply%20to%20the%20cells%20standard%20phone%20number%20format%20as%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20451px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F208007i94076E93B25FE7F8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20to%20modify%20it%2C%20if%20necessary%2C%20in%20Custom%20menu.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20apply%20select%20range%20with%20cells%2C%20Ctrl%2B1%20and%20as%20above.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546839%22%20slang%3D%22en-US%22%3ERe%3A%20Dashes%20in%20phone%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546839%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20open%20the%20format%20cells%20dialog%20box%20and%20select%20the%20special%20category%2C%20Excel%20has%20a%20built-in%20format%20option%20for%20phone%20numbers.%20If%20you%20prefer%20a%20dash%20as%20opposed%20to%20parentheses%20for%20the%20area%20code%2C%20select%20the%20phone%20number%20format%20and%20then%20click%20on%20the%20%22custom%22%20category%20and%20you%20can%20modify%20that%20format%20to%20remove%20the%20parentheses%20in%20lieu%20of%20a%20dash.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 Replies
Highlighted

@Bob_Irvine 

You may apply to the cells standard phone number format as

image.png

and to modify it, if necessary, in Custom menu.

 

To apply select range with cells, Ctrl+1 and as above.

Highlighted

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.