Display numbers as fractions - Excel - Office Support - Office 365


Sign in

Apps Install Account Training Admin

Display numbers as fractions Applies To: Excel 2016, Excel 2013, Excel 2010, Excel 2007

Use the Fraction format to display or type numbers as actual fractions, rather than decimals. 1. Select the cells that you want to format. 2. On the Home tab, click the Dialog Box Launcher next to Number.

3. In the Category list, click Fraction.

4. In the Type list, click the fraction format type that you want to use.

Fraction format

This format displays 123.456 as

Single-digit fraction

123 1/2, rounding to the nearest single-digit fraction value

Double-digit fraction

123 26/57, rounding to the nearest double-digit fraction value

Triple-digit fraction

123 57/125, rounding to the nearest triple-digit fraction value

Fraction as halves

123 1/2

Fraction as quarters

123 2/4

Fraction as eighths

123 4/8

Fraction as sixteenths

123 7/16

Fraction as tenths

123 5/10

Fraction as hundredths

123 46/100

The number in the active cell of the selection on the worksheet appears in the Sample box so that you can preview the number formatting options that you select.

Tips for displaying fractions After you apply a fraction format to a cell, decimal numbers as well as actual fractions that you type in that cell will be displayed as a fraction. For example, typing .5 or 1/2 results in 1/2 when the cell has been formatted with a fraction type of Up to one digit. If no fraction format is applied to a cell, and you type a fraction such as 1/2, it will be formatted as a date. To display it as a fraction, apply a Fraction format, and then retype the fraction. If you don't need to perform calculations on fractions, you can format a cell as text before you type a fraction into it by clicking Text in the Category list. This way, the fractions that you type will not be reduced or converted to decimals. However, you cannot perform mathematical calculations on fractions that are displayed as text. To reset the number format, click General in the Category box (Format Cells dialog box) or in the Number Format box (Home tab, Number group). Cells that are formatted with the General format do not have a specific number format.

Connect with an expert CONTA CT US

Expand your skills E X P LORE TRA I NI NG

Was this information helpful?




Display numbers as fractions - Excel - Office Support - Office 365

Sign in Apps Install Account Training Admin Display numbers as fractions Applies To: Excel 2016, Excel 2013, Excel 2010, Excel 2007 Use the Fractio...

403KB Sizes 2 Downloads 12 Views

Recommend Documents

Excel Glossary - Excel - Office Support - Office 365
An address can be a URL (Web address) or a UNC path (network address), and can include a specific location within a file

Basic tasks in Excel - Excel - Office Support - Office 365
Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and tr

Apply data validation to cells - Excel - Office Support - Office 365
Use data validation rules to control the type of data or the values that users enter into a cell. One example of validat

Export notes as a PDF - OneNote - Office Support - Office 365
If you want to share some of your notes, but don't want to give someone full access to all of them, you can export notes

Featured Excel Templates - Office Templates - Office 365
Featured Excel Templates. Welcome to Excel Excel · Formula tutorial Excel · PivotTable tutorial Excel · Simple budget Ex

Add and subtract numbers - Excel for Mac - Office Support - Office 365
Adding and subtracting in Excel is easy; you just have to create a simple formula to do it. Just remember that all formu

Introduction to queries - Access - Office Support - Office 365
You can use a query to answer a simple question, to perform calculations, to combine data from different tables, or even

Basic tasks in Word 2013 - Word - Office Support - Office 365
Opening documents, reading, track changes and other basic tasks in Microsoft Word 2013. ... Microsoft Word 2013 is a wor

Set up Office 365 file storage and sharing - Office Support
Aug 21, 2017 - Learn how to set up Office 365 collaboration, file sharing, and file storage to store files in the cloud

Best practices for Outlook 2010 - Outlook - Office Support - Office 365
Learn ways to better manage your email messages, calendar, and tasks in Outlook 2010.