New answers tagged google-sheets-cell-format
1
To my experience most methods fail.
The one I find most useful is:
Write the fraction as a formula: =19/20
Under Format -> More Formats->Custom number format use: _# ??/??
1
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 ...
0
Put the numerator and denominator in different cells. Use an extra column to calculate the decimal representation of the fraction (eg d2 = b2/cd) to use in calculations, and convert the original cells to text for display use.
Top 50 recent answers are included
