software

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 (formatgt;cellsgt;numbergt;customgt;general). Do you have
any other suggestions to my problem?

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.

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

quot;Leaquot; wrote:

gt; I have a series of numbers I have to convert to a ratio. Does have a
gt; function to do this? I have tried the following formula=B26/c26 and then
gt; converting the number to (formatgt;cellsgt;numbergt;customgt;general). Do you have
gt; any other suggestions to my problem?

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:

?????/?????

quot;Leaquot; wrote:

gt; I have a series of numbers I have to convert to a ratio. Does have a
gt; function to do this? I have tried the following formula=B26/c26 and then
gt; converting the number to (formatgt;cellsgt;numbergt;customgt;general). Do you have
gt; any other suggestions to my problem?