2

I'm trying to add fractions to Google Sheets document. However, any time I enter 1/12, it's automatically converted to the date 1/12/2017

Fraction being converted to a date

How can I prevent this from happening?

2

Short version: Use the custom number format _# ??/?? for regular fractions, or # ??/?? for mixed fractions.


Add an = sign so the cell contains =1/12. If it doesn't display as the decimal number 0.08333, reset the cell's formatting with Format -> Number -> Automatic.

Numbers displayed as decimals

To make the cell display as a fraction, we can use a custom number format courtesy of math-faq.com. Highlight the cells you want to format and select Format -> Number -> More Formats -> Custom number format.... To format as a fraction, enter the number format _# ??/??.

Numbers displayed as fractions Custom number format for fractions

Bonus Tip: If you want to use mixed fractions, remove the _ and use the number format # ??/??.

Numbers displayed as mixed numbers Custom number format for mixed numbers

  • or for short vulgar fractions, # ?/?? – Crissov Apr 19 '17 at 6:58
  • When typing a fraction directly, such as 3/16, this doesn't work. The fraction is immediately converted to a date, like 3/16/2019 – Ryan Griggs Jun 5 at 12:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.