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

  • Thread starter Thread starter Jack W
  • Start date Start date
J

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.
 
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.
Click to expand...

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
 
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.
 
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.
Click to expand...

Obviously, I did not make that assumption. Certainly would make things
simpler.
--ron
 
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
 
Back
Top