Learn Excel Now

Conquer the Fear of Excel

Keep up to date on all the newest live trainings, events, and tutorials.

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Excel Number Formatting Special: Phone Numbers

June 1, 2016 by Tyrone Pernsley

Excel gives you the power to format your numbers in a ton of different ways. Today’s post is focusing on one specific, special format: phone numbers. We here at Learn Excel Now are continuously surprised by the number of people who say they didn’t know this was an Excel Feature. So, to help make sure everyone using Excel knows how to create special number formatting, we created the following quick tip.

Let’s say you exported a customer list from your database in an Excel file. There is no formatting in the new file and looks a bit like this:

Excel Number Formatting Image 2

So, the first thing you do is automatically expand the columns and possibly add a bit of color to the spreadsheet so it looks like this:

Excel Number Formatting Image 1

Now, in order to change the numbers to phone numbers, you will need to:

  • Highlight the cells containing the data you want to format
  • Click on the dropdown button on the Number tab of the Home Ribbon

Number Formatting

  • On the Format Cells dialogue box that opens, click Special and then Phone Number

Excel Number Formatting Image 3

Once you click Okay, the cells automatically format as phone numbers:

Excel Number Formatting Special - Phone Numbers

You will see there are other options on the Special formatting:

  • Zip Code
  • Zip Code + 4
  • Phone Number
  • Social Security

Any of these options will allow you to format the numbers in an easy to read way.

We hope you enjoyed this week’s quick tip on formatting Excel for numbers.

Like Learn Excel Now? Sign up for our newsletter to stay up-to-date on all things Excel?

And don’t forget to follow us on social media and share our Excel tips with your social networks!

Kevin – Learn Excel Now

Filed Under: Formatting Tagged With: Excel 2013, Excel formatting

Keep up to date on all the newest live trainings, events, and tutorials.

Comments

  1. Donald Davis says

    June 1, 2016 at 1:18 pm

    helpful. I had forgotten what was in the special formatting so appreciated the review. If forgotten then I will not think about it the next time I will need it. Keep them coming.

  2. Elaine I. Matthews says

    June 14, 2016 at 6:39 pm

    That is the “coolest” thing. Thank you!

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

Sitemap

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-800-964-6033
384 Technology Drive
Malvern, PA 19355

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2020 ­ Learn Excel Now

Copyright © 2021 · News Pro Theme on Genesis Framework · WordPress · Log in