Excel Training Videos

How to enter fractions in a cell in an Excel worksheet

  1. Enter 0 (zero)
  2. Enter a space
  3. Now enter your fraction, for example, 3/7
  4. Press enter to complete the process
  5. You can now use various functions like sum to perform calculations with fractions!






Reference

How to enter fractions in a cell in an Excel worksheet