Forum Discussion
vasthoagies
Oct 03, 2019Copper Contributor
Phone Number Format
Hello! I am new to the forum but have been an Excel user for many years. On previous versions it was so easy to format all phone numbers by selecting the cells and changing the format to "Special" an...
PReagan
Oct 03, 2019Bronze Contributor
Hello vasthoagies,
Just so I am understanding correctly, per your example, you would like a cell containing "+1 XXXXXXXXXX ext:" to be formatted as "+1 (XXX)-XXX-XXXX ext"?
Are all cells formatted this way? Are some formatted as simply "XXXXXXXXXX"?
- vasthoagiesOct 07, 2019Copper Contributor
PReagan Yes, that is what I am trying to accomplish. Some are in that format already, others are the international format. Thanks.