How to Format Phone Numbers in Excel | Create a Custom Number Format in Excel

Published: 06 July 2022
on channel: Excel, Word and PowerPoint Tutorials from Howtech

152,456

387

In this video, we’ll show you How to Format Phone Numbers in Excel.

Every country has a different country code and format of writing phone numbers. Sometimes getting phone numbers to display correctly in Excel can be tricky, but with number formatting these issues can be resolved.

Let’s do this!

1) Open your Excel file and select the numbers you want to format.
2) Go to the home tab and Click the drop-down arrow in the Number area of the ribbon.
3) Select the Number tab, then choose Special from the list of options.
4) In the Type section on the right, select the Phone Number option and click OK.
5) If you’d like a different format for these numbers, select them and right-click the selection.
6) Click on the Format Cells option, then select Custom.
7) Enter the format you want. When you’re done, click OK.

This is how we can format our contacts!

❓💬 What other tips do you want to know? Let us know in the comments below.

#HowTech #Excel
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here https://t.me/howtechtv
✅ Commercial questions [email protected]
✅ Facebook   / howtechtv
✅ Instagram   / howtechprojects
✅ Twitter   / howtechprojects

Watch video How to Format Phone Numbers in Excel | Create a Custom Number Format in Excel online, duration hours minute second in high quality that is uploaded to the channel Excel, Word and PowerPoint Tutorials from Howtech 06 July 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 152,456 times and liked it 387 visitors.

673