How to display fractions in Excel

In excel when we type fractions like ‘1/2’, ‘1/3’, it shows dates like 01-Feb, 01-Mar. To display fractions and stop converting in to dates you can follow the below mentioned steps.

  • Select the cells or columns where you want the fractions to appear.
Showing dates instead of fraction
  • Right click and select Format Cells option
  • Under the Number tab select Fraction.
  • Select the type of fraction you want. For this example we are going with ‘Up to one digit’. Click Ok to save the changes.

You might be interested in this post as well – Dash becomes date in Excel


Leave a Reply

Your email address will not be published. Required fields are marked *