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 – Disable conversion numbers with dash to dates in Excel
Leave a Reply