How to Format Binary Fractions Like 1-1/2 in Excel
Question details
The user needs to properly format measurement values as specific binary fractions (such as halves, quarters, eighths, and sixteenths) without Excel incorrectly simplifying or altering the desired denominators.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Entering specific measurements commonly used in fields like construction or woodworking, where a precise power-of-two denominator is required.
- Observed behavior
- Excel automatically simplifies fractions to their lowest terms, or automatic fraction formats select denominators that do not match the required construction measurements.
Ensure that your cell data is correctly entered as numbers (decimals) rather than text strings, so that Excel's number formatting rules can be successfully applied.
Apply Built-in Fraction Formatting Options
Use Excel's default fraction formatting to quickly display numbers in halves, quarters, or eighths depending on your measurement needs.
Excel has several built-in fraction formats that cover the most common binary denominators. Choosing the correct digit precision or fixed denominator helps maintain accurate data presentation.
Highlight the specific cells or column containing the measurements you want to format.
Right-click the selected area and choose "Format Cells" from the context menu, or press the Ctrl + 1 keyboard shortcut.
Navigate to the "Number" tab and click on "Fraction" in the Category list on the left side.
Select the format that best fits your measurement, such as "Up to one digit (1/4)" or "As eighths (4/8)", and click OK.

Create a Custom Fraction Format for Fixed Denominators
Define a custom formatting rule to lock your measurements into a specific binary denominator, such as exactly sixteenths or thirty-seconds.
Format Fractions Perfectly with WPS Spreadsheet
WPS Office provides an intuitive, highly compatible spreadsheet application that makes formatting complex measurements and custom fractions effortless.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet containing the measurement data.
- 2. Access cell formatting: Select the cells you want to modify, right-click, and select "Format Cells".
- 3. Apply custom fraction rules: Navigate to the Custom tab, input your required binary fraction format like '# ??/16', and click OK to instantly update your sheet.

Frequently Asked Questions
How do I stop Excel from converting my fractions into dates?
To prevent Excel from auto-formatting fractions as dates, either pre-format the cells as 'Fraction' or 'Text' before entering your data, or type a zero and a space before your fraction (for example, type '0 1/2' instead of '1/2').
Can I force all my measurements to display as sixteenths?
Yes. You can use a custom number format to lock the denominator. Open the Format Cells dialog, select the Custom category, and enter the code '# ??/16'. This forces every fractional value in those cells to display in sixteenths.
Why does Excel simplify 4/8 to 1/2 when I need it unsimplified?
Excel's default fraction behavior reduces values to their lowest common denominator to remain mathematically accurate. To display unsimplified fractions, you must use a fixed custom format like '# ?/8'.




