Help Me Convert Fraction

[Charlie Brandon]

I'm trying to customize a worksheet to read the fractions such as 14/16 as
7/8, 4/16 as 1/4, 8/16 as 1/2 etc. Can this be done and if so, does anyone
out there explain to me how to do this? I'm using Excel2000. Thanks!! CB

 

[J.E. McGimpsey]

Take a look here:

http://www.mvps.org/dmcritchie/excel/fractex1.htm

 

[Ron Rosenfeld]

I'm trying to customize a worksheet to read the fractions such as 14/16 as
7/8, 4/16 as 1/4, 8/16 as 1/2 etc. Can this be done and if so, does anyone
out there explain to me how to do this? I'm using Excel2000. Thanks!! CB

Round the results to the largest denominator you want.

For example, if you want to round to the nearest 1/16, round your result using
the formula: =ROUND(num*16,0)/16

Then format the cell to show fractions up to two digits. If you use a custom
format, it'll be something like # ??/?? but you probably have that as a
built-in format.


--ron