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.