You may find that entering fractions in Excel is frustrating – for example, Excel will interpret 5/8 as a the date “May 8” and format the cell as such. To enter a fraction that Excel can recognize, begin the formula with a 0, add a space and then type the formula. Using the above example of 5/8, you would type: =0 5/8. Excel will interpret the entry as .625 and apply the Fraction format to the cell.
Similar Posts:
- Using a Named Range in Excel
- Using 3-D Formulas and References in Excel
- Naming a Range in Excel
- Entering in Functions Manually in Excel
- Using the VLOOKUP Function in Excel
- Shortcut Keys in Excel
- Adding space between right-aligned text and border in Excel
Comments on this entry are closed.