Write Vacationer Phone Number with airSlate SignNow

Write patron phone number

hello and welcome to another Excel demo with rich Kirk in this short video we'll take a look at how one can apply phone number formatting to a range of cells so I've got a couple of names in column a and I've entered one phone number in cell b2 and I'd like to format cell b2 and b3 so we'll format a cell that has data and then we'll apply it in advance for cell b3 I'm going to select the range of cells in question in this case b2 and b3 and the phone number formatting is not found directly on the Home tab in the number section so we can get to our format cells a number of ways of course we could hit the drop arrow for the for the number formatting and come down to more number formats that would do it for us or we can launch the full cells formatting window with the launcher button in the number section my preferred method is still control and the number one so we press ctrl + 1 on your keyboard that launches the format cells window and now that I've got that launched I'm going to the special category of phone of a number of number formats and on my locale is set to English us which will be appropriate in my scenario and I will apply phone number formats and you'll even see that if your anchor cell in your spreadsheet is on a 10 digit number you'll see the format take effect right here in this window so I'll choose OK and there is the phone number for Jinni I'll go to Grace and say that her phone number is 7 7 3 7 7 7 93 11 and when I hit the enter key the formatting takes over that's it that's how you apply phone number formatting in Microsoft Excel thanks for watching and please come back soon for more excel videos have a great day