Help Me Convert Fraction

  • Thread starter Thread starter Charlie Brandon
  • Start date Start date
C

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
 
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
Click to expand...

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
 
Back
Top