How to Enter Numbers with Fractions in a Cell in Excel 2016

Learn how to enter fraction values in to a cell in Excel 2016. If you want to display a fraction value as true fraction in Excel, for example 8.5 you want to show it as 8 1/2 then you can type the value differently into spreadsheet so that the display is like fraction. Even though you entered a fraction the value of the cell will be shown in formula bar as decimal value, 8 1/2 will be shown as 8.50.

• #people_blogs
• #fractions
• #enter_fraction
• #cell_value_fraction
• #how_to_enter_decimal_value_as_fraction_in_excel
• #fraction_entry_in_excel
• #find_easy_solution