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.
- 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
Questions? Corrections? Issues and pull requests are always welcome.
This post is licensed under
CC BY 4.0
by the author.