Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Converting Numbers to Percentage in Excel

February 10, 2016 by Tyrone Pernsley

Cell formatting in Excel allows you to represent your numbers in a variety of ways: as a date, as a percentage, as currency, and with custom formatting, even phone numbers. In today’s quick tip, we are going to show you how to quickly change a number to a percentage in Excel.

After entering a number or an array of numbers into different cells, you can format them (or format the cell before the number is entered – your preference).

To convert the values to a percent:

  • Highlight the desired cells
  • Right click them
  • Click the Format Cells option
  • Click the Number category
  • Then chose the percentage tab

This will give you the option to change how many decimals points you desire to show. After you have picked your desired decimal points, click OK and bam, it is now a percentage!

Percentage in Excel GIf 1

Tip: you can also click on the lettered column heading to convert the all cells within the column to your formatting preference. This is good for spreadsheets where you will be adding values over time, so that you don’t have to keep reformatting each time.

Note:  if you apply the percentage format to existing numbers in a spreadsheet, excel multiplies the numbers by 100 to convert them to percentages. (If a cell contains 20, it will covert to 2000.00 %).

To format empty cells, follow the same procedure for formatting cells with existing values. Tip: you can also click on the lettered column heading to convert the all cells within the column to your formatting preference. This is good for spreadsheets where you will be adding values over time, so that you don’t have to keep reformatting each time.

Percentage in Excel GIF 2

As with many functions in Excel, there is another way to this as well using the Ribbon – the top toolbar in Excel.

Percentage in Excel Image 1

To change numbers to a percentage in Excel using the Ribbon, click on the Ribbon, make sure you are on the home Ribbon tab. The go to the number tab and use the dropbox to select percentage. On this tab, you can also use the decimal arrow keys to select the number of decimal places you want.

Percentage in Excel GIF 3

We hope you found today’s quick and easy lesson on converting numbers to a percentage in Excel beneficial. Don’t forget to follow ups on Social Media and subscribe to the blog to get convenient, quick tips like this, and other great Excel training tips so that you can take the fear out of Excel.

Like Learn Excel Now? Sign up for the newsletter!

-Kevin, Learn Excel Now

Excel Power Tips: Shortcuts that Save Time & Eliminate Frustration
Simplify your life with essential Excel tips & shortcuts that will save you time and impress your colleagues.
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.

Most Popular On-Demand Webinars

  • Excel Essentials: Most Needed Skills in Today's Workplace
  • Excel Power Tips: Incredible Shortcuts that Save Time & Reduce Frustration
  • Excel Formulas & Functions Bootcamp
  • Excel Dashboards for Beginners: Present Your Data Like a Pro
  • Advanced Formulas & Functions in Excel: Solve Your Data Challenges

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.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

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

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

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

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In