MrExcel Publishing
Your One Stop for Excel Tips & Solutions

reducing fractions and showing 8/16's as 1/2 etc.

Posted by Jim on January 28, 2001 1:08 PM

I need to reduce my fractions to the nearest 16th but
show 4/16's as 1/4 and 8/16's as 1/2 etc. I've tried
custom number format ( #??/16 ) and Mr Excels tip of
week both still show 4/16's etc. My formula that gives
the result as a fraction is:
Any help or ideas would be appreciated
Thanks, Jim

Posted by Celia on January 28, 2001 1:40 PM

Format as #???/??? and change your formula to :-