Digital Answers

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.

Showing dates instead of fraction

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

Exit mobile version