First, Format cells Fraction Select Up to one digit (1/4)

then enter 2/4 press enter it will automatic convert to 1/2


"NILELATOR" wrote:

I have a spreedsheet that i need to get answers in the form of fractions in
1/8's, 1/4's, and 1/2's depending on which one. I all I can find is one or
the other not all is there any way to get the answer the way I want ie....
instead of 2/4 I need 1/2, and 1/4 instead of 2/8.

help please