chem101
10-26-2010, 08:15 AM
Hello Everyone,
I need your help. I'm using a spreadsheet that calculates sizes of a rectangle. I used Format Cells option to show the result in 16th's of an inch. Is there any way to have Excel reduce improper fractions? For example Excel may provide an answer of 15 8/16. How can this be automatically reduced to 15 1/2?
Thank you for any assistance you can provide!
I need your help. I'm using a spreadsheet that calculates sizes of a rectangle. I used Format Cells option to show the result in 16th's of an inch. Is there any way to have Excel reduce improper fractions? For example Excel may provide an answer of 15 8/16. How can this be automatically reduced to 15 1/2?
Thank you for any assistance you can provide!