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

Written by Osman Goni Ridwan

Last updated: Jul 12, 2024

We have some data in fraction format and need to convert the fractional numbers to the percentage format.

Method 1 – Convert Fractions to Percentages with Number Format Commands

STEPS:

Select the cells with the fraction format.
Go to the Home tab.
In the Number group, click the percentage “%” symbol.

Alternatively, you can find the Percentage format in the drop-down menu.

The cells in fractional format are in the percentage format.
You may find a problem that the value in percentage format are integers and there are no decimal digits.

Go to Home and Number.
You will see two options below the percentage icon. The left one will increase the digits after the point and the right one will decrease the digits after the point.

Here’s our result with two decimal values.

Read More: Convert Fraction to Decimal in Excel

Method 2 – Use the Custom Format Option

STEPS:

Select the cells first which will be converted to percentage format.
Go to the Home tab and, in the Number group, select the arrow in the bottom-right corner of the group.
A window will open named Format Cells.

Select the Custom option from the Category.
Input the format in the Type box that you want or select any options shown below the box. You will see the preview in the Sample box.
Press OK.

Here’s the result.

Read More: How to Write a Fraction in Excel

Download the Practice Workbook

Format Fraction to Percentage.xlsx

Related Articles

<< Go Back to Fraction in Excel | Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

SaveSavedRemoved 0

Tags: Fraction in Excel

Osman Goni Ridwan

OSMAN GONI RIDWAN is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, OSMAN has transitioned into the role of a content developer. Specializing in creating technical content exclusively centered around Excel... Read Full Bio

2 Comments

Reply
Randall Helweg Jan 2, 2026 at 5:14 AM

I am inputting a fraction in an “INPUT CELL” as text (a basketball statistic >> FG [Field Goal. ex: 13/15]. In a “report table elsewhere on worksheet, I want to look up the “INPUT CELL” and display the value STILL as a “fraction displayed as test” in a column and in the column NEXT to it, I was look at the SAME “INPUT CELL” AND DISPLAY the fraction as a PERCENTAGE%.
- Reply
  Shamima Sultana Jan 4, 2026 at 7:07 PM
  
  Hello Randall Helweg,
  
  You can do this by treating the same input cell in two different ways—once as text and once as a calculated value.
  
  If your INPUT CELL (say A1) contains the text 13/15:
  1. To display it as a fraction (text)
  In your report table column, simply reference the cell directly:
  =A1
  Make sure the cell format is Text so Excel doesn’t try to calculate it.
  
  2. To display it as a percentage in the next column
  Convert the text into a calculation using a formula like:
  =LEFT(A1,FIND(“/”,A1)-1)/MID(A1,FIND(“/”,A1)+1,LEN(A1))
  Then format this cell as Percentage (%).
  
  This way, you are:
  1. Displaying the original fraction exactly as entered in one column
  2. Showing the calculated FG percentage from the same input cell in the next column
  No need to change how the user inputs the data—Excel can handle both views from the same cell.
  
  Regards,
  ExcelDemy

Leave a reply Cancel reply

Submit Excel Problem