Easily Enter Fractions into Excel

Add to Favorites
Author:

This is a very simple trick to enter fractions quickly without having to manually format anything. This allows you to quickly enter fractions in the fraction format without having to first convert them to decimals and then format it separately.  This will save you a lot of time.

Steps to Enter Fractions Quickly

  1. Type a zero 0 in the cell:
  2. Hit the Space bar and then type your fraction:
  3. Hit Enter and that's it!

Excel will have saved the fraction as a decimal, look to the formula bar in Step 3 above where it says 0.5. The cell will also have been turned into the Fraction number type, which is what displays the decimal number like a fraction.

If you double-click the cell with the fraction, you will see the decimal representation of it:

Notes

The zero that you type before the fraction will disappear once you hit the Enter key, so don't worry about that.

Download the sample file for this tutorial to follow along.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
How to Enter Data into Excel
Tutorial: Entering data into Excel is exactly the same across all Excel versions and can be done in ...
Format Cells as a Fraction in Excel Number Formatting
Macro: This free Excel macro will automatically format a selected cell or many selected cells in ...
Use a Form to Enter Data into a Table in Excel
Tutorial: You can enter data into a table in Excel using a form; here I'll show you how to do that....
Understanding Formulas and Functions in Excel
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...
Excel Import Web Data Copy/Paste + Easy Analysis
Tutorial: How to easily bring data into Excel from the web using copy/paste and then quickly transf...
Excel Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course