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.

Formatting Numbers as Architectural Fractions in Excel

To format numbers as architectural fractions in Excel, follow these steps:

1. Select the cell or range of cells that you want to format.
2. Right-click on the selection and choose "Format Cells" from the context menu.
3. In the "Format Cells" dialog box, select the "Number" tab.
4. Under "Category," select "Fraction."
5. Under "Type," select "Up to one digit (1/4)" or "Up to two digits (1/8)" or "Up to three digits (1/16)" depending on the precision you want.
6. Click "OK" to apply the formatting.

Displaying Numbers as Architectural Fractions

To display a number as an architectural fraction, use the following formula:

Here's how it works:

1. Multiply the number by 16 to get the equivalent 1/16th value.
2. Round the result to the nearest whole number using the ROUND function.
3. If the rounded value is 16, display "1/4" using the IF function. Otherwise, display the fraction using the "&" operator to concatenate the rounded value with "/16".

Copy this formula to other cells as needed to display other numbers as architectural fractions.

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