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

Hi Jack,

Simply format the cell (Format|Cells|Number Fraction 'up to 2 digits').

--
Cheers
macropod
[Microsoft MVP - Word]


"Jack W" <Jack wrote in message ...
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.