Last Updated on February 4, 2023 by Jake Sheridan
In this tutorial, you will learn how to convert fractions to decimals in Google Sheets.
How To Convert Fraction To Decimal in Google Sheets
Google Sheets makes it easy to work with numbers in various formats. Numbers can be represented in percentages, currencies, dates, and more.
If you’re dealing with fractional values, you can choose to either display them as fractions (½) or as a decimal (0.5)
But what should you do if you are given numbers formatted as fractions and you need to convert them into decimal values?
In this guide, we will show you a few simple methods you can use to quickly and easily convert fractions to decimals in Google Sheets. We will explain how to use the TEXT function and the number formatting options to change how fractions are formatted in your sheets.
How To Format Fractions As Decimals in Google Sheets
Here’s how to format fractions as decimals in Google Sheets.
First, we’ll use a Google Sheets function to convert fractions into decimal.
Select an empty cell to place the result of our formula.
Next, we’ll type the TEXT function into the empty cell. The TEXT function requires two arguments: the number to format, and the desired format.
In the example above, we’ve chosen to format the fraction in cell A2 first. We specified the format “0.00” which should return a decimal number with up to two decimal places.
Evaluate the function and copy the formula down the column to convert the rest of the fractions.
We can also use Google Sheets’ built-in custom number formatting options.
To start, select the cell or cell range you want to convert into a decimal.
Select the option Format > Number > Custom number format.
Type the format “0.00” in the provided textbox.
You may modify this format if you want to output more or less decimal places in your final result.
Hit the Apply button to proceed.
The fraction values in your selected range should now be formatted as decimals.
This guide should be everything you need to convert fractions to decimals in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.