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.

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.

On Mon, 15 Feb 2010 08:14:01 -0800, Jack W Jack
wrote:

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

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.

--
Cheers
macropod
[Microsoft MVP - Word]


"Ron Rosenfeld" wrote in message ...
On Mon, 15 Feb 2010 08:14:01 -0800, Jack W Jack
wrote:

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

On Tue, 16 Feb 2010 10:56:44 +1100, "macropod"
wrote:

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

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

Previous Posts In This Thread:

On Monday, February 15, 2010 11:14 AM
Jack W wrote:

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.

On Monday, February 15, 2010 11:28 AM
macropod wrote:

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').

--
Cheers
macropod
[Microsoft MVP - Word]

On Monday, February 15, 2010 12:42 PM
Ron Rosenfeld wrote:

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 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

On Monday, February 15, 2010 6:56 PM
macropod wrote:

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 case
the formatting is sufficient.

--
Cheers
macropod
[Microsoft MVP - Word]

On Monday, February 15, 2010 7:22 PM
Ron Rosenfeld wrote:

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


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


Submitted via EggHeadCafe - Software Developer Portal of Choice
Crypto Obfuscator for .NET - Product Review
http://www.eggheadcafe.com/tutorials...or-for-ne.aspx