How to Put Fractions in Google Sheets [Guide 2022]

How To Put Fractions In Google Sheets 21

Google Sheets is typically used for spreadsheet collaboration across different users. Spreadsheet application enables users to create, edit and format spreadsheets online to organize and analyze information and process complicated numbers. Fractions are also part of complex numbers which is sometimes difficult to deal with in Google Sheets. A fraction has two parts, namely the numerator, and denominator. The number on the top is called the numerator, and the number on the bottom is called the denominator.

The numerator defines the number of equal parts taken, whereas the denominator defines the total number of equal parts in a whole. Although Google sheet is a smart spreadsheet tool, you may have trouble inserting fractions in Google Sheets as they can convert into dates. Directly entering the fractions in the Google Sheets can interrupt you to understand whether it is a regular fraction number or a simple text string. But you do have not to worry, this article is to get rid of all those problems. In this tutorial, we will learn several methods for how to put fractions in Google Sheets properly without error.

Importance of using Fractions in Google Sheets

If you are working on any financial project consisting of numbers and figures. Sheets make it seamless for teams to work together. Easily add collaborators to projects, see changes as they occur, receive notifications for edits that happen while you’re away, and chat with colleagues in the same document. Fraction is also a basic function of math that is commonly used in spreadsheet applications. While making reports, bills, or any other document that has fraction values usually written in the format of the decimal point for example (1.2, 3.25, etc.). Sometimes you may not like this format and you need to put fractions in Google Sheets then you are right to the place.

If you are facing a problem while putting the fractions in Google as we discussed above, usually inserting the fractions converts the text into fractions, or either it becomes as simple as it looks like a simple text. Then this tutorial is for you where we will learn an official proper way how to put fractions in Google Sheets. Therefore, this article is going to be very helpful to resolve all these problems which you need to learn. So, let’s start without wasting our time.

See also  Version History in Google Sheets (Complete Beginner's Guide)

How to Put Fractions in Google Sheets

Putting fractions in Google Sheets is not rocket science, even you can use a slash sign on your keyboard to put the fraction but it can take you a long process to convert different decimals and can cause errors. Therefore, here we are going to learn a couple of ways to put the fractions in Google Sheets which will automatically calculate the data and convert it into fractions.

  1. Putting fractions in Google Sheets by using a forward slash sign
  2. Putting fractions in Google sheet by using the Text function
  3. Putting fractions in Google sheet by using Customs Number formats

How to Put Fractions in Google Sheets – Using Forward Slash Sign

Simply we can put the fraction by using the forward slash sign. But there may be found some problems while directly putting the fractions in Google Sheets.

Step 1

Just write the numerator and use the forward slash sign and then the denominator.

How To Put Fractions In Google Sheets 1

Step 2

But in Google Sheets, they are usually converted into dates as you can see below.

How To Put Fractions In Google Sheets 2

How to Put Fractions in Google Sheets – Using the TEXT function

The TEXT function in Google Sheets allows you to convert a number and text according to a specified format. Similarly, we can use the text function to show our decimals values into fractions.

Syntax

=TEXT(number, “format”)

There are only two arguments in the syntax: first is the applied number, reference cell, or range and second is the specified format in which you want your text.

Here we want to make our values in the form of fractions. There is a specified format in Google Sheets used for putting fractions.

Format

“# ?/?”

Character  Description
# It represents a digit in the number for the reminder, and would not show the insignificant 0.
/ A forward slash is used to show fractions.
? just like hash, a ? also represents a digit in the number for the denominator and numerator and would also not show the insignificant 0, but the insignificant 0 will appear as space.

 

Let’s see how it practically works.

Step 1

Open Google Sheets and take a blank sheet.

How To Put Fractions In Google Sheets 3

Step 2

This is our sample data in the form of decimals values which we will convert into fractions.

How To Put Fractions In Google Sheets 4

Step 3

Select the cell where you want to put the fraction.

How To Put Fractions In Google Sheets 5

Step 4

Then we will write down the TEXT function.

How To Put Fractions In Google Sheets 6

Step 5

Then according to syntax first we will give the reference cell address as shown in the image below.

How To Put Fractions In Google Sheets 7

Step 6

Now we have to insert the format that we have discussed above.

How To Put Fractions In Google Sheets 8

Step 7

Once when you complete your formula hit Enter to get the results. If you write the syntax correctly, you will also get the results below.

How To Put Fractions In Google Sheets 9

Step 8

If your number of lists, then you can simply drag your answer to get the all other’s answers.

How To Put Fractions In Google Sheets 10

In the above picture, you can see that fractions values have also reminder values. If you don’t want to get the reminder with the fractions then you can just remove the “#” sign from the syntax to get only fractions values without reminder value as you may see in the following steps.

Step 9

Here. You can see the change in the syntax, I have just removed the “#” sign which was representing reminder value.

How To Put Fractions In Google Sheets 11

Step 10

Now, you can see the below reminder value has been removed, fractions have just a denominator and numerator.
How To Put Fractions In Google Sheets 12

Note: As I have a single-digit value in my data so I used single “?” in the fraction format, if you have a double-digit value in your data then you will use double “??” in the fraction format.

For example, for double-digit decimals values, the syntax will be as =TEXT(A2, “??/??”)

See also  How to Use HLOOKUP Function in Google Sheets (User Guide)

How to Put Fractions in Google Sheets – Using Custom Number Formats

There is another way of putting fractions in Google Sheets by using customs number formats. Google Sheets custom number format rules are used to specify special formatting rules for numbers. These custom rules control how numbers are displayed in your Sheet, without changing the number itself. They’re a visual layer added on top of the number. It’s a powerful technique to use because you can combine visual effects without altering your data. Similarly, we can use the same above format to show our values in fractions by using a custom number format as well. Let me show you how to put the fraction in Google Sheets by using the customs number format.

Step 1

Let’s take some samples of data

How To Put Fractions In Google Sheets 13

Step 2

Select all the values that you want to make fractions.

How To Put Fractions In Google Sheets 14

Step 3

Then follow the following track, Go into the format tab in the menu bar, and then Numbers, you will find the customs number format at last in the drop-down menu.

How To Put Fractions In Google Sheets 15

Step 4

The Custom number format dialogue box will open.

How To Put Fractions In Google Sheets 16

Step 5

We will write the format of text formatting, In customs number format we will use the same format rule as we study in the above method.

How To Put Fractions In Google Sheets 17

Step 6

Now to apply to the format just click on the “apply” button.

How To Put Fractions In Google Sheets 18

Step 7

As you click on the apply button, all values will automatically be formatted into the fractions as you can see below.

How To Put Fractions In Google Sheets 19

 

Frequently Asked Questions

Q: How to convert decimals to fractions with the fixed denominator?

A: In some cases, we need to divide our all values with the same divider or denominator, we can do the same thing in Google Sheets as well with just little changes in the format of fractions. Let me show with the help of examples,

Step 1

Let’s suppose this is our data which we want to divide by fixed divider.

How To Put Fractions In Google Sheets 20

Step 2

Here we have little changed the format of fractions, just write the number in the denominator that you want to use instead of a question mark.

How To Put Fractions In Google Sheets 21

Note: Here we used the TEXT function for converting fractions by the fixed denominators, but it is not compulsory to use the TEXT function, you may use the custom number format as well just use the same format rule.

Step 3

As you can see from the result, all values have been divided by the “10

How To Put Fractions In Google Sheets 22

Here we used the fixed denominator “?/10”, If you want to divide your values by halves then you can use “?/2” similarly for quarters use “?/4” and so on.

Q: How do you subtract fractions in Google Sheets?

A: The Subtract fraction in Google Sheets is the same as subtracting other values. Click on an empty cell, write the first value and use the minus symbol and then write the second value and hit enter, you will get your results.

Q: Can we convert fractions into percentages?

A: Yes! You can convert the fractions to a percentage in Google Sheets as well. You just have to change the number formatting. In the format tab, select the percentage format of numbers to convert fractions to a percentage.

See also  How to Use Absolute and Relative Cell References in Google Sheets

Conclusion

This was all about how to put Fractions in Google Sheets. You will shock after knowing that when we directly put the fractions in the Google Sheets, it automatically converts into dates which can cause your formatting and formula to error. So, there were some different ways to put the fractions in Google Sheets hope you got them all. This method can take you a couple of minutes but it will get rid of errors and give you proper fractions.

So, I hope this tutorial, on how to put fractions in Google Sheets found very helpful to you for more interesting topics, stay connected with Office Demy.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

We will be happy to hear your thoughts

Leave a reply

OfficeDemy.com
Logo
Enable registration in settings - general