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!
You should read it
- How to write the above index, below index in Excel
- Write a program to check duplicate values in Python
- Filter data that doesn't overlap in Excel - Filter for unique values in Excel
- How to copy values in Excel
- How to write exponential numbers in Excel
- How to convert a CSV file to Excel
- How to round up sums in Excel
- The way to sum the same codes in Excel
- How to write leading zeros in Excel
- MINA and MAXA functions in Excel
- Write a program to find duplicate values in Python
- MODE.MULT function - The function returns a vertical array of the most common values in Excel