How to display Numbers as Fractions in Excel

Download PC Repair Tool to quickly detect & prepare Windows errors automatically

Have you tried to enter a fraction into your Excel sheet, simply when you press enter, it turns into a serial, whole, or decimal number, and you have no inkling what to practise? In Microsoft Excel, you tin can catechumen a number into a fraction using the Fraction format.

What is a Fraction format in Excel?

In Math, a fraction definition is a numerical quantity that is not a whole number, merely in Excel, fractions are a number format used to display the numbers as fractions instead of numbers. The formatting of Excel functions comes with several options, such as upward to one digit, 2 digits, three digits, halves, quarters, eighths, sixteenths, etc.

How to display Numbers as Fractions in Excel

Follow the steps below to display numbers as fractions in Microsoft Excel.

Select the cell you want to format
Click the dialog box launcher adjacent to Number on the Home tab
In the Category listing on the left pane, click Fraction
In the Type list on the right, click the fraction format type y'all desire to see.
And then click OK

Launch Excel.

Blazon a decimal or a whole number into the cell.

Click the dialog box launcher next to Number on the Dwelling tab

A Format cells dialog box will open up.

In the Category list on the left pane, click Fraction.

In the Type list on the right, click the fraction format type you lot want to see, namely:

The preview of the fraction format will brandish in the Sample box.

Then click OK.

come across the result above.

There are two other methods in Excel that convert a number into a fraction.

Method 1, On the Home tab, click the Number Format button and select the Fraction option.

If you lot want to change the fraction format, click More Number formats to brandish the Format cells dialog box.

Method two is to right-click the cell and select Format jail cell.

The Format cell box will open.

Click Fraction from the category listing, and then choose a fraction format.

And so click OK.

Related: Fix The file is corrupt and cannot be opened error in Discussion, Excel, PowerPoint.

We promise this tutorial helps y'all empathise how to brandish numbers as fractions in Excel; if y'all have questions nearly the tutorial, let us know in the comments.

Shantel is a university student studying for Bachelor of Science in Information Applied science. Her goal is to become a Database Administrator or a Organization Administrator. She enjoys reading and watching historical documentaries and dramas.