View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jack W Jack W is offline
external usenet poster
 
Posts: 1
Default How to format numbers as architectural fractions (1/16,1/8,1/4 )

How do I format a number to the 1/16ths, but display the answer as an
architectural fraction? Example: I want to display .25 as 1/4 rather than
4/16, but want to round to 1/16 precision.