View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jack Deuce Jack Deuce is offline
external usenet poster
 
Posts: 30
Default Help with formula (decimal to fraction)

I'd like to be able to convert decimal to fraction of an inch. IOW I
have calculated, from the circumference, the diameter (d=c/3.14) and
would like to show the actual inches instead of the decimal
equivalent. 6.250 decimal would display 6 1/4, 6.375 decimal would
display 6 3/8.

Thanks in advance