Ratio function

L

Lea

I have a series of numbers I have to convert to a ratio. Does have a
function to do this? I have tried the following formula=B26/c26 and then
converting the number to (format>cells>number>custom>general). Do you have
any other suggestions to my problem?
 
J

JMB

Is the Fraction format what you're looking for?

Format/Cells/Fraction

If you need more than 3 places you could use a custom format and add more ?
marks. Following would show 5 digits in the numerator and denominator.

# ?????/?????
 
J

JMB

One other thing, you could create a custom format and remove the leading #
sign to remove the whole number and express the entire thing as a fraction:

?????/?????
 
Top