How to write fractional values in Excel

Sometimes you enter fractions into Excel data cells but it shows the time format. You do not know how to handle the input data is displayed as a fraction.

There are many ways to help you format data cells and the following article shows two ways to help you easily write fractional formulas in Excel spreadsheets.

Step 1: You need to open the Excel file, select (black out) the data cells you want it to display correctly according to the input value as a fraction.

Then right-click and choose Format Cells .

$How to write fractional values in Excel Picture 1$

Step 2: In the Format Cells dialog box, select the Number tab and in the Category section, select Fraction .

$How to write fractional values in Excel Picture 2$

Step 3: In the Type section, select the type of fraction display:

- Up to one digit (1/4): displays the numerator and denominator with only one digit.

- Up to two digits (21/25): displays the numerator and denominator up to two digits.

- Up to three digits (312/943): displays the numerator and denominator up to three digits.

After selecting you click OK .

$How to write fractional values in Excel Picture 3$

After formatting is complete, you enter the fraction data into those cells again, the data will display the fraction type as you wish.

$How to write fractional values in Excel Picture 4$

Also you can do the following:

Step 1: Select the cells you want to write the fraction formula to, right-click and choose Format Cells .

$How to write fractional values in Excel Picture 5$

Step 2: In the Number tab of the Format Cells dialog box, select Custom . In the Type of Custom you enter # ??? / ??? Can you write more question marks? on the numerator or denominator to display an additional number of digits on the numerator and the denominator. The example here shows up to 3 digits on the numerator and the sample. Then click OK .

$How to write fractional values in Excel Picture 6$

Step 3: You enter the fractions into the formatted cells, the numbers will be displayed as desired.

$How to write fractional values in Excel Picture 7$

With simple operations, you can write fractions in Excel spreadsheets easily and quickly. Good luck!

Isabella Humphrey

Update 19 May 2020

You should read it

May be interested

Insert text anywhere in Word
insert text into any position in word, the following article shows some ways to insert text in the margins of a page with features available in word.
How to filter data in Excel
your excel spreadsheet has a lot of data, so it's easy to process and search the data in your table. filter data by conditions, criteria you give, you will shorten the search time and data processing
How to create a table and insert a table in Excel?
for better data management in excel, creating tables for excel data is essential. you can easily search, calculate, manage and analyze data ... but the way to create tables is very simple, so you can quickly create tables in the
Tips with spreadsheets (sheet) in Excel
in excel spreadsheets to manage excel data using sheet tabs, you can easily add, delete, rename or customize the settings as you like for the worksheets in excel worksheet. here are some basic tips when working with sheets in e
How to merge mail (Mail Merge) in Word
mail merge (mail merge) is a useful feature in microsoft word, this feature helps you reduce the time when processing list inserts into a fixed form such as invitations, notices, thank you letters, report card…
Instructions for creating Macros in Excel
macros help you save time when performing repetitive steps in excel. you can refer to how to create and use macros in excel in the following article.

How to write fractional values ​​in Excel

You should read it

May be interested

Office information

How to write fractional values in Excel