Return to Answer

Use the format option :

[![enter image description here][1]][1]

or Format -> Number -> More Formats -> Custom number format...

Solution 1 : Use 0.0"/20" as a custom format on the cell containing 19.5.
WARNING : It has still the value 19.5 but is display as 19.5/20.

Solution 2 Use the ??/20 custom format on a cell with =19.5/20

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. [1]: https://i.sstatic.net/f0xuY.png

Use the format option :

or Format -> Number -> More Formats -> Custom number format...

Solution 1 : 

Use 0.0"/20" as a custom format on the cell containing 19.5.
WARNING : It has still the value 19.5 but is display as 19.5/20.

Solution 2

Use the ??/20 custom format on a cell with =19.5/20

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.

Use the format option :

[![enter image description here][1]][1]

or Format -> Number -> More Formats -> Custom number format... Then type ??/20

Long story short : it has the value 19.5 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. [1]: https://i.sstatic.net/f0xuY.png

Use the format option :

[![enter image description here][1]][1]

or Format -> Number -> More Formats -> Custom number format...

Solution 1 : Use 0.0"/20" as a custom format on the cell containing 19.5.
WARNING : It has still the value 19.5 but is display as 19.5/20.

Solution 2 Use the ??/20 custom format on a cell with =19.5/20

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. [1]: https://i.sstatic.net/f0xuY.png

Use the format option :

[![enter image description here][1]][1]

or Format -> Number -> More Formats -> Custom number format... Then type ??/20

Long story short : it has the value 19.5 but will display a round number I.E. 20/20 here. Having decimals within a fraction is way more complicated and is another question. [1]: https://i.sstatic.net/f0xuY.png

Use the format option :

[![enter image description here][1]][1]

or Format -> Number -> More Formats -> Custom number format... Then type ??/20

Long story short : it has the value 19.5 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. [1]: https://i.sstatic.net/f0xuY.png