• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Fraction

How to display fractions in Excel

December 17, 2022 by Admin Leave a Comment

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

Filed Under: Excel Tagged With: Excel, Fraction

Primary Sidebar

Recent Posts

  • Streamline your Excel spreadsheets with these easy steps to hide rows and columns
  • Effortlessly Convert Text Cases in Excel with These Methods
  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel

blogmines.com Copyright © 2023