{"id":365,"date":"2018-06-27T17:52:26","date_gmt":"2018-06-27T17:52:26","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=365"},"modified":"2024-03-30T10:48:33","modified_gmt":"2024-03-30T10:48:33","slug":"simple-fractions-and-decimals-fractions","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/","title":{"rendered":"Simple Fractions and Decimal Fractions in Excel"},"content":{"rendered":"\n

You can find two types of fractions in Excel: simple fractions<\/strong> (e.g. 4\/5<\/strong>) and decimal fractions<\/strong> (e.g. 1.34<\/strong>). In this lesson, I will show you how to use them.<\/p>\n\n\n\n

Decimal fractions<\/h2>\n\n\n\n

The decimal fraction (12.432) has the decimal part and the fractional part. They are separated by a dot (comma in some countries).<\/p>\n\n\n\n

Excel will automatically recognize the value as a decimal as soon as you confirm your entry. By default, when you type a fraction, Excel will treat it as a\u00a0General<\/strong> type, so each number will be saved with different precision.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Number of decimal places<\/h2>\n\n\n\n

If you want these numbers to be treated as decimal fractions, select them and open the Format Cells <\/strong>window (Ctrl + Shift + F)<\/strong>. In the Number<\/strong> tab, in the Category<\/strong> box, click Number<\/strong> from the list.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Set the number of decimal places<\/a> (in this example I used 2 decimal places).<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Notice that the value in cell B3<\/strong> has been rounded<\/a>. If you click it, you will see that in the formula bar<\/a> it is still 78.5678<\/strong>. It means that when you change the display precision the information is not lost.<\/p>\n\n\n\n

If you want to change the number of decimal places, you can perform the same operation again, this time choosing a different number.<\/p>\n\n\n\n

However, there is another, the faster method you can use to achieve the same result. You can change precision by using one of two buttons: Increase Decimal<\/strong>\u00a0and\u00a0Decrease Decimal<\/strong>. You’ll find them in\u00a0HOME >> Number<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select the values from B2<\/strong> to B4<\/strong> and click one of the buttons to increase or decrease decimal places.<\/p>\n\n\n\n

Simple fractions<\/h2>\n\n\n\n

To enter a simple fraction (e.g. 2 3\/5<\/strong>), select a cell and enter the value from the keyboard. After you accept, Excel will display it in the same way in which it was entered. If you click this cell, notice that the value is only displayed as a simple fraction, but Excel still remembers it as a decimal fraction.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

When Excel treats the fraction as a date<\/h3>\n\n\n\n

If you enter a simple fraction that doesn\u2019t contain an integer value (e.g.\u00a02\/3), and the cell is of a general type, then Excel will recognize this value as a date (February 3<\/strong>). If you want this value to be treated as a simple fraction, you need to do one of two things.<\/p>\n\n\n\n

    \n
  1. Before you enter this value, format the cell to the fractional type,<\/li>\n\n\n\n
  2. Enter 0<\/strong> in the decimal place (e.g. 0 2\/3<\/strong>).<\/li>\n<\/ol>\n\n\n\n

    Excel converts a simple fraction to the lowest denominator<\/h3>\n\n\n\n

    After you enter the number 1 4\/8<\/strong>, Excel will automatically convert this value to the form of the smallest denominator (1 1\/2<\/strong>). If you want this value to be stored as 1<\/strong> 4\/8<\/strong>, go to the number formatting<\/a>, click the Fraction<\/strong> category and select As<\/strong> eighth (4\/8)<\/strong>.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Converting simple fractions to decimal fractions<\/h2>\n\n\n\n

    Simple fractions can be converted to decimal fractions as well as decimal fractions to simple fractions. But in both cases, there may be problems with precision.<\/p>\n\n\n\n

    First, look at how to convert a\u00a0simple fraction<\/strong>\u00a0to a\u00a0decimal fraction<\/strong>.<\/p>\n\n\n\n

      \n
    1. 1 2\/5<\/strong> will be changed to 1.4<\/strong>. In this case, both fractions are exactly the same.<\/li>\n\n\n\n
    2. Try to convert\u00a02 2\/3<\/strong>\u00a0to a decimal fraction. If you choose the\u00a0Number<\/strong>\u00a0format, then the value will be converted to\u00a02.67<\/strong>. Notice that when you click this value, in the formula bar it will be stored with a much higher precision\u00a0of 2.66666666666667<\/strong>. But even this number won\u2019t be exactly the same as (2 2\/3<\/strong>).<\/li>\n<\/ol>\n\n\n\n

      Converting decimal fractions to simple fractions<\/h2>\n\n\n\n

      The situation gets even more complicated if you try to change a decimal fraction to a simple fraction. Take, for example, the number\u00a01.2345<\/strong>. Go to\u00a0Format Cells\u2026<\/strong>\u00a0(Ctrl + Shift + F<\/span><\/strong>). In the\u00a0Number<\/strong>\u00a0tab, click\u00a0Fraction.<\/strong>\u00a0At the top, you will find three positions: with one, two, and three digits in the denominator. The more numbers in the denominator, the greater the precision.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Example:<\/h3>\n\n\n\n

      Here are some examples:<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Experiment with other positions and check which option in a particular situation is best for you.<\/p>\n","protected":false},"excerpt":{"rendered":"

      You can find two types of fractions in Excel: simple fractions (e.g. 4\/5) and decimal fractions (e.g. 1.34). In this lesson, I will show you how to use them….<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[190],"yoast_head":"\nSimple Fractions and Decimal Fractions in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to work with fractions in Excel, including simple and decimal fractions. Explore how to change the number of decimal places and enter simple fractions into cells.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Simple Fractions and Decimal Fractions in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to work with fractions in Excel, including simple and decimal fractions. Explore how to change the number of decimal places and enter simple fractions into cells.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-27T17:52:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-30T10:48:33+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/diffrent-precisions.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Simple Fractions and Decimal Fractions in Excel\",\"datePublished\":\"2018-06-27T17:52:26+00:00\",\"dateModified\":\"2024-03-30T10:48:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/\"},\"wordCount\":690,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/diffrent-precisions.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"training\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/\",\"url\":\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/\",\"name\":\"Simple Fractions and Decimal Fractions in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/diffrent-precisions.png\",\"datePublished\":\"2018-06-27T17:52:26+00:00\",\"dateModified\":\"2024-03-30T10:48:33+00:00\",\"description\":\"Learn how to work with fractions in Excel, including simple and decimal fractions. Explore how to change the number of decimal places and enter simple fractions into cells.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/diffrent-precisions.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/diffrent-precisions.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Simple Fractions and Decimal Fractions in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Simple Fractions and Decimal Fractions in Excel","description":"Learn how to work with fractions in Excel, including simple and decimal fractions. Explore how to change the number of decimal places and enter simple fractions into cells.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/","og_locale":"en_US","og_type":"article","og_title":"Simple Fractions and Decimal Fractions in Excel","og_description":"Learn how to work with fractions in Excel, including simple and decimal fractions. Explore how to change the number of decimal places and enter simple fractions into cells.","og_url":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/","article_published_time":"2018-06-27T17:52:26+00:00","article_modified_time":"2024-03-30T10:48:33+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/diffrent-precisions.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Simple Fractions and Decimal Fractions in Excel","datePublished":"2018-06-27T17:52:26+00:00","dateModified":"2024-03-30T10:48:33+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/"},"wordCount":690,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/diffrent-precisions.png","keywords":["pinterest"],"articleSection":["training"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/","url":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/","name":"Simple Fractions and Decimal Fractions in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/diffrent-precisions.png","datePublished":"2018-06-27T17:52:26+00:00","dateModified":"2024-03-30T10:48:33+00:00","description":"Learn how to work with fractions in Excel, including simple and decimal fractions. Explore how to change the number of decimal places and enter simple fractions into cells.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/diffrent-precisions.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/diffrent-precisions.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/training\/simple-fractions-and-decimals-fractions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Simple Fractions and Decimal Fractions in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/365"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=365"}],"version-history":[{"count":9,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/365\/revisions"}],"predecessor-version":[{"id":17404,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/365\/revisions\/17404"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}