I'm trying to put some marks in a spreadsheet and have a lot of unsimplified fractions or fractions like 19.5/20. Is there a way to enter fractions and have the cells be usable in other formulas, while keeping them displayed as originally entered?
Use the format option :
Format -> Number -> More Formats -> Custom number format...
Long story short : it has the value
19.5/20 = 0.975 but will always display a round numerator with
/20 denominator. I.E. 20/20 here.
Having decimals within a fraction is way more complicated and is another question.