Formatting Numbers to Percentages
Suppose that we are working on a data set containing decimal values needed to be converted into percentage values.
In the above example, we want to convert the value of the percentage field to percent format (%)
For that we will use the convert to percentage option available under the Home tab inside the number category.
Select all the values you want to convert and then click on the percent icon.
Under this Number section.
All the values will be converted to percentages. Something like this:
Well remember that we first applied the formula =(marks_scored/total_marks) i.e. in this case is =(B2/$A$9), that gave results in decimal and only after that we converted them into percent.
What excel does after clicking on the convert to percent is that the value inside the cell is multiplied by 100 and then the percent (%) symbol is added.
If you will apply percent formatting into a cell containing value 45 it will return 4500% which may not be ideal for you.
To quickly apply the percentage format, you can use the keyboard shortcut: CTRL+SHIFT+%
Changing Decimal Places
If you want to limit the decimal places in your data or want to round off the decimal places to a certain digit without going much deeper into the custom number formatting options.
There is an easy way out which works in a click.
Let us again try to understand this with an example.
Suppose we want to round this number to two digits.
Under the Home Tab -> Number Category -> 
For every one click of the left mouse button, the button with the right arrow adds one zero after the last decimal place.
And for each click, the button with the left arrow rounds off the decimal to one place.
In our example we had 9 digits after the decimal place. To limit it to 2 decimal places, we clicked 7 times to get a number which rounded itself after each click.
Similarly, if you click the button with the right arrow, you’ll get back the original digits.
In this way you can easily deal with decimal numbers.
Want to know how anchoring and grouping cells work? Click here.
Sources:
At TechnoExcel :
You can upskill yourself with:
Why us?
Techno Excel is a leading provider of Excel courses and data analytics courses. We not only teach you how to use excel but also help customize it for your exact needs! Make the most out of your career with Techno Excel. Students can join via classroom course or via Online course. This is the place where students can easily learn the required skill set to get placed immediately
Learn data science and other technologies at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace. Whether you are a beginner or a professional looking for advanced techniques, we have the right course for you. Hurry up!! Book your seat now!!!
Class-room of your choice
Upskill yourself by attending classroom or online class.
Flexible timings
Learn at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace.
Class-Room Size
With limited students in class, attention to each student's performance will be given.
Industry Ready Curriculum
The course is designed for people who want to work in the industry.
Book your free consultation now
If you want to improve your skills and get ready for the workforce! Please enter your information below, and one of our expertise will contact you shortly.
