View original (French)

Fractions in Google Sheets

Bemanace Posted messages 63 Status Member -  
 Anonymous user -
Hello,
it's impossible to input fractions in Google Sheets cells; it automatically converts them to dates, and I can't find a custom number format that works.
Can someone help me?
Thanks in advance.

5 answers

  1.
    Bemanace Posted messages 63 Status Member 9
     
    It works by combining what I learned from both of you:
    the cell format found with eriiic's idea and Raymond's "=1/3" allows me to enter the correct value.

    Thanks to both of you, problem solved
    (I’ll leave the topic open for a while, you never know if someone has something to contribute!)
    4
    1. Marc
       
      Good evening,
      I have a similar problem, maybe you could help me before I pull my hair out.....
      In Google Sheets, I enter a list of numbers for data validation. They need to appear in the dropdown menu as fractions. Then formulas apply to them. So these numbers cannot be considered as text. Help!! :-)
      0
      1. Anonymous user > Marc
         
        Marc,

        First, you need to change the format of the text in the cells or the entire column: Format/Number/Other Formats by setting it to #" "?/?
        Then you enter your fractions with an "=" in front, e.g. =1/2
        and it should work

        --> Bemanace

        For the continuation of the discussion, please create a new topic by clicking on "Ask your question"
        0