meetinglaha.blogg.se

Then, you will get the following contact numbers into the Social Security Number format. In this section, we will use the Social Security Number option for changing the numbers in general format into social security numbers. Method-3: Using Social Security Number Option for Excel Phone Number Format Read More: Keep 0 Before a Phone Number in Excel (6 Methods) In this way, you will get your desired phone numbers in the Zip Code + 4 format Then, the Format Cells dialog box will pop up ➤ Select the phone numbers of the Contact Number column You can also use the inbuilt Zip Code + 4 option for having the phone number formats of the contact numbers which are in general format. Method-2: Using Zip Code+4 Option for Excel Phone Number Format Read More: How to Format Number with VBA in Excel (3 Methods) In this way, you will get your desired phone number format where the first three digits in brackets represent the area code. ➤ Click the Dialog Box Launcher besides the Number group under the Home tabĪfter that, the Format Cells dialog box will appear ➤ Select the range of cells where you want to have the phone number format For this purpose, we will use here the inbuilt Phone Number option of Excel. But we can convert them into a standard format so that you can easily understand that it is a phone number. Here, we have the contact numbers of the employees of a company in general number format. Method-1: Using Phone Number Option for Having Excel Phone Number Format Here, we have used the following table for demonstrating the examples of using phone number format in Excel.įor creating the article, we have used Microsoft Excel 365 version, you can use any other versions according to your convenience. 8 Ways to Use Phone Number Format in Excel