Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
In Excel by default the fractional values are displayed in decimals, fractions in excel are number formats where the fractions are displayed as the actual fractions rather than the decimals, they can be accessed from the format tab of the excel and then from the category list we can choose fraction and now our numbers will be in fraction format not in decimal format.
Fraction Number in Excel
We all deal with numbers in excel, we make some formatting to numbers in excel to look better and readable. Especially when we work with decimal numbers we usually maintain two decimal points to read the number correctly.
For example, if you want to show 1.5 in the cell we need to maintain at least one decimal point to read that as 1.5 or else it will show as 2.
Well, we all know this technique early on in the excel learnings. If you recollect your mathematics class in your school your math teacher must have taught about fractions.
There is an alternative method to write decimal numbers in fractions. For example, instead of writing 0.5 we can write ½, instead of writing 0.25 we can write ¼, we can write 0.75 as ¾. Yes, we apply this technique to excel as well.
We do not see this kind of numbers of formatting techniques in excel quite often. But instead of showing the number as 1.5 we can show as 1 ½.
We could be able to see these kinds of numbers usually in stock market share prices. In equity market industry you must hear people taking in a fraction like “Co., A acquired ¼ (one fourth)of shares, Co., C sold its 2/3 (two third of) of shares to other company.
Because we do not get to see these kinds of fraction numbers regularly in excel we are presenting this article on Fraction numbers in Excel. Go through this entire article and learn about fraction numbers in excel.
How to Format Numbers as Fractions in Excel?
In excel we can format the numbers as fractions in a couple of ways. We can format numbers as fractions in two ways one is by using Number format under the Home tab and the second one is using Format Cell option.
Method #1 – Format by Using Home Tab
I have few numbers from cell A1 to A10 with decimal points. Let’s convert them into fractions using the Home tab.
Select all the numbers from A1 to A10.
Go to Home tab and under Number click on the drop-down of Number Format.
Select Fraction option from this drop-down list.
Now it will convert all the decimal number to fractions.
Method #2 – Format by Using Format Cell Option
Take the same numbers from the previous example where I have data from cell A1 to A10 with decimal points. Let’s convert them into a fraction by using the Format Cell option.
Step 1: Select the cells from A1:A10
Step 2: Right-click on cells and select Format Cells.
Step 2.1: Instead of right click and select Format Cells you can press the shortcut key Ctrl +1. You will see below the window.
Under this window select Fraction. Here we will see all kinds of fraction options under this. Select the first one.
Click on ok to complete the procedure. Now we will see fraction numbers instead of decimal numbers.
How to use Fraction Numbers in Excel?
Now we will look at using fraction numbers practically. We will prepare a list of ingredients required for Biriyani preparation. Below are the ingredients required for Biriyani.
Let us create a template in excel sheet.
Now we have quantity in the column C. In kitchen terminology decimal numbers usual thing. We need to show then in a fraction.
Apply any one of the above 2 methods.
Now it is actually in kitchen terminology.
Things to Remember
- We can create a fraction up to 3 digits.
- We can ofsee an actual decimal number in Formula bar.
- If you multiply 1/4 with 2 the result will be ½.
- We can show fractions in two ways one as 4’s i.e. ¼, 2/4, ¾, and another one as 8’s i.e. 2/8, 4/8, 6/8.
This has been a guide to Fraction Number in Excel. Here we discuss how to format Fractions in Excel using Home Tab and Format Cell Option along with practical uses of fractions in excel. You may also look at these useful functions in excel –