Ratio function
 

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 (formatcellsnumbercustomgeneral). Do you have
any other suggestions to my problem?

Ratio function
 

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.

# ?????/?????

"Lea" wrote:

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 (formatcellsnumbercustomgeneral). Do you have
any other suggestions to my problem?

Ratio function
 

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:

?????/?????

"Lea" wrote:

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 (formatcellsnumbercustomgeneral). Do you have
any other suggestions to my problem?