Forum Discussion
Bob_Irvine
Jul 26, 2020Copper Contributor
Dashes in phone numbers
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?
SergeiBaklan
Jul 26, 2020Diamond Contributor
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.
Microsoftonipad
Mar 05, 2023Copper Contributor
Hi SergeiBaklan
I’m trying convert an entire column of numbers into the phone number format, but I can only convert one number / one cell at a time even though I’ve selected the letter at the top of the column, and the whole column is highlighted. I’m working on an iPad. Do you have any suggestions on how to convert the entire column all together?