Thread: Fractions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jct6641 jct6641 is offline
external usenet poster
 
Posts: 5
Default Fractions

When converting a decimal to a fraction, I get some responses like 1/67 when
what I am looking for is increments of 1/64. Then I want to display 10/64 as
5/16 or 32/64 as 1/2 etc.
Can this be accomplished in an excel formula or combination of nested
formulas?