Thread
:
How to format numbers as architectural fractions (1/16,1/8,1/4 )
View Single Post
#
3
Posted to microsoft.public.excel.misc
macropod[_2_]
external usenet poster
Posts: 293
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.
Reply With Quote
macropod[_2_]
View Public Profile
Find all posts by macropod[_2_]