If you're working with a lot of data in Excel, you may find yourself needing to format phone numbers. Unfortunately, there's no built-in way to do this in Excel. However, there is a workaround that you can use to conditionally format phone numbers. Here's how:
That's it! The phone numbers in your selected cells should now be formatted according to your specifications.
Note: This method will only work for phone numbers that are 10 digits long. If you have other formats (e.g. 11 digits or 12 digits), you'll need to use a different formula.
Tip: You can also use conditional formatting to format email addresses and website URLs. For more information, see this article.