{"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 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\nDecimal fractions<\/h2>\n\n\n\n