Forum Discussion
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?
Hi Bob Irvine,
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?
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?
Hi dear,
If your phone numbers are text or text formatted, you need to make them numbers first, then apply the formatting.
If your phone numbers are text or text formatted, you need to make them numbers first, then apply the formatting.