# How to Format Fraction to Percentage in Excel (2 Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

While making reports or calculations in Excel, we often need to use percentage values. To convert percentage from fraction, we multiply the value by 100 and add the percentage symbol (%) after. But Excel will do it automatically if we can convert it to percentage format. This article will show you how to format a fraction into a percentage in Excel.

## How to Format Fraction to Percentage in Excel: 2 Swift Methods

Suppose you have some data in fraction format and you need to convert the fractional numbers to percentage format in Excel. Here, I will show you 2 easy and quick methods to convert the fractional numbers to percentage format in Excel. ### 1. Convert Fraction to Percentage with Number Format Commands

Using number format commands is the simplest method to convert fractional numbers to percentage format in Excel. For this, follow these steps:

📌 STEPS:

• First, select the cells in fraction formats.
• Then, go to the Home tab. And in the Number group, you will see an option in the percentage “%” symbol. Finally, select that option. • Alternatively, you can find the Percentage format in the drop-down menu.
• For this, open the drop-down menu and select the Percentage option. • Now, the cells in fractional format are in the percentage format.
• But, you may find a problem that the value in percentage format are integers and there are no decimal digits. • But, you may need the decimal digits also. For this, select the cells again.
• And, go to Home > Number.
• Like the screenshot, you will see two options. The left one will increase the digits after the point and the right one will decrease the digits after the point.
• So, press on the left option two times to increase two digits after the decimal point. • Finally, you will have the fractional values in the percentage format. Read More: Convert Fraction to Decimal in Excel

### 2. Use Custom Format Option

You can also use the Custom Format option to convert the fractional cells to the percentage format. Here, I will show the steps on how to use the Custom Format option to format fractions to percentages.

📌 STEPS:

• As like before, select the cells first which will be converted to percentage format.
• Now, go to the Home tab and in the Number group, you will select the arrow in the bottom-right corner of the group.
• After that, a window will open named “Format Cells”. • Now, in the Format Cells window, keep remaining in the Number tab.
• Then, select the Custom option from the Category.
• After that, input the format in the Type box that you want or select any options shown below the box. Here, you will the preview in the Sample box.
• Finally, press OK. • As a result, you will see the cells of fractional numbers are in the percentage format. Read More: How to Write a Fraction in Excel

## Related Articles Osman Goni Ridwan

I am Ridwan, graduated from Naval Architecture and Marine Engineering Dept, BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands. My prime goal is to be a data analyst as I do love to solve problems and play with data.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  