Quadratic Roots from Decimal to Fraction

[andreascostas]

I found UDF that gives the roots to ax^2+bx+c=0 using the quadratic formula.
The roots are given in decimals. Is there an easy way to change the decimals to improper fractions?
Example: for 15x^2+52x+45=0 the unction returns the roots as -1.8 and -1.667 each in separate cells.
What I need is a way to change -1.8 to -9/5 and -1.667 to 5/3
Can that be done? And how do I format the cells?

 

[MrKowz]

You should be able to accomplish this with number formats.

Highlight the range of cells you want this to affect, then right click on them and go to Format Cells>Number (Tab)>Custom and enter ?/? into the Type field.

Hope this helps!

 

[andreascostas]

Thank You.

 

[inactiveuserps07]

@andreascostas, given the nature of quadratic equations, you probably want to use MrKowz' method above, but use ??/?? as the Custom format.