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

Leave a Reply

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