PDA

View Full Version : Solved: Fractions



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!

Bob Phillips
10-26-2010, 08:45 AM
Format it as

0 0/?

chem101
10-26-2010, 09:29 AM
Thank you for your reply. I'm having some trouble with your solution. That formatting returns a value of 5 0/1 when applied to 5 2/16. Any other recommendations??

Thank you.

Bob Phillips
10-26-2010, 09:36 AM
It shows as 5 1/8 for me, so no, no other suggestions.