Fractions in Microsoft Excel

In this article, you’ll get to know about Fractions in Excel. It’s about how to format the fractional values that you entered.

How to format fractional values in Microsoft Excel?

  • Select the cell which has a fractional value i.e, decimal numbers in it.
  • Now right-click on the cell you chose or use Ctrl+1 to open the Format dialog box.

Another way to open the format dialog box is by clicking on the arrow in the bottom right corner of the Number group in the Home tab.

Fractions in Excel
How to format fractional values in Microsoft Excel?
  • Go to Fractions in Category under the Number tag.
Fractions in Excel
  • Now in Type, you’ll find a list of formats.
Fractions in Excel
Fractions in Excel
  • Here you can select any one of the formats you wish.
Fractions in Excel
  • Click on OK to save the changes you made.

Then you can view the change in your worksheet.

Fractions in Excel

This way fractional numbers can be formatted.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...