In this article:

How to Convert Fraction to Percent in Google Sheets (2024)

May 8, 2024

How to Convert Fraction to Percent in Google Sheets

Follow the steps below to convert fractions to percentages in Google Sheets using the REGEXEXTRACT function. This method treats fractions entered as text, which can be especially useful if Google Sheets isn't interpreting your fractions as expected.

1. Input Your Fractions as Text

First, input the fractions into column A of your Google Sheets document starting from cell A1. Type them exactly as shown below, treating them as text entries:

how to convert fraction to percent in google sheets

Make sure to directly type the fractions into the cells without any formatting.

2. Use the REGEXEXTRACT Formula

In cell B1, input the formula to convert the text fraction in A1 into a decimal. Use the following formula:

=ArrayFormula(if(len(A1:A), regexextract(A1:A, "^\d+") / regexextract(A1:A, "\d+$"), ""))

convert fraction to percent google sheets

This formula will work down column A, converting any fraction it finds into a decimal equivalent. It checks if the cell is not empty (if(len(A1:A)), extracts the numerator (regexextract(A1:A, "^\d+")), extracts the denominator (regexextract(A1:A, "\d+$")), and performs the division.

3. Convert to Percentages

The formula will give you decimal results in column B. To convert these decimals to percentages, you need to format column B as a percentage.

fraction to percent google sheets

Select column B by clicking on the "B" at the top of the column. Go to the "Format" menu, choose "Number," then select "Percent."

google sheets fraction to percent

Now, the decimal values in column B will be formatted as percentages.

4. Adjust Decimal Places (Optional)

You might notice that the percentages are rounded to the nearest whole number or have too many decimal places. To adjust this: With column B still selected, use the "Increase decimal places" or "Decrease decimal places" buttons in the toolbar to achieve the desired precision.

We hope that you now have a better understanding of how to convert fraction to percent in Google Sheets. If you enjoyed this article, you might also like our article on how to sort by month in Google Sheets or our article on how to insert euro symbol in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->