How to format numbers as architectural fractions (1/16,1/8,1/4 )

[Jack W]

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.

 

[macropod]

Hi Jack,

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

 

[Ron Rosenfeld]

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.

You cannot do that just with formatting.

If you merely set the format to display as fraction with up to two digits,
which has been suggested, then you will not round to 16ths.

You *DO* need to set the format to fraction with up to two digits. But:

What is required is either a VBA routine, which will alter your entry "on the
fly" to round to 16ths, or set up your worksheet so that the value is entered
in one cell; and then in a "helper column" you have a formula to do the
rounding: e.g. =ROUND(A1*16,0)/16

--ron

 

[macropod]

Hi Ron,

My understanding is that the input value was already in a decimal value equivalent to 16ths (of an inch, presumably), in which case
the formatting is sufficient.

 

[Ron Rosenfeld]

My understanding is that the input value was already in a decimal value equivalent to 16ths (of an inch, presumably), in which case
the formatting is sufficient.

Obviously, I did not make that assumption. Certainly would make things
simpler.
--ron

 

[Bob Markowski]

it will display in Feet, inches and fractions:

=CONCATENATE((INT(C9/12)),"'-",INT((C9/12-INT(C9/12))*12+0.001),IF(C9-INT(C9)>0,TEXT((C9-INT(C9))," #??/??"),""),"""")

C9 is a decimal number that you want converted



Jack W wrote:

How to format numbers as architectural fractions (1/16,1/8,1/4 )
15-Feb-10

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

Previous Posts In This Thread:

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 a
architectural fraction? Example: I want to display .25 as 1/4 rather tha
4/16, but want to round to 1/16 precision.

Hi Jack,Simply format the cell (Format|Cells|Number > Fraction > 'up to 2
Hi Jack

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

-
Cheer
macropo
[Microsoft MVP - Word]

wrote:You cannot do that just with formatting.
wrote

You cannot do that just with formatting

If you merely set the format to display as fraction with up to two digits
which has been suggested, then you will not round to 16ths

You *DO* need to set the format to fraction with up to two digits. But

What is required is either a VBA routine, which will alter your entry "on th
fly" to round to 16ths, or set up your worksheet so that the value is entere
in one cell; and then in a "helper column" you have a formula to do th
rounding: e.g. =ROUND(A1*16,0)/1

--ron

Hi Ron,My understanding is that the input value was already in a decimal value
Hi Ron

My understanding is that the input value was already in a decimal value equivalent to 16ths (of an inch, presumably), in which cas
the formatting is sufficient

-
Cheer
macropo
[Microsoft MVP - Word]

wrote:Obviously, I did not make that assumption.
wrote

Obviously, I did not make that assumption. Certainly would make thing
simpler
--ron


Submitted via EggHeadCafe - Software Developer Portal of Choice
Crypto Obfuscator for .NET - Product Review
http://www.eggheadcafe.com/tutorial...f8-f5fd987fafb1/crypto-obfuscator-for-ne.aspx