How to Display Excel Fractions as Eighths (0/8 and 1 0/8)
Question details
The user needs to format numeric values in a spreadsheet to display as fractions specifically in eighths, ensuring that a zero appears as 0 0/8 and a whole number like one appears as 1 0/8.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Formatting fractional data for specific industry standards (like construction or stock pricing) without converting the numerical data into text.
- Observed behavior
- The values must be visually represented as fixed-denominator fractions (eighths) while fully retaining their underlying numeric properties so they can still be used in mathematical calculations.
Ensure the cells you want to format contain actual numerical values, as text entries will not be affected by custom number formatting.
Apply Custom Number Format for Eighths
Use the Custom Format feature to force numbers to display as mixed fractions with a strict denominator of 8.
By default, spreadsheet software reduces fractions to their lowest common denominator (e.g., 2/8 becomes 1/4). To force the display to always show eighths, even for whole numbers or zero, you need to apply a specific custom format code.
Highlight the range of cells containing the numbers you want to format as eighths.
Right-click on the selected cells and choose "Format Cells" from the context menu, or press the shortcut keys Ctrl + 1.
In the Format Cells dialog, go to the "Number" tab and select "Custom" from the Category list on the left side.
In the "Type" input box, enter the exact code: 0 0/8. Click "OK" to apply the formatting.

Format Fractions Effortlessly with WPS Spreadsheet
WPS Spreadsheet offers robust custom formatting options identical to Microsoft Excel, allowing you to display fractions exactly as you need them while keeping your files lightweight and fully compatible.
- 1. Open your workbook: Launch WPS Spreadsheet and open the document containing your numerical data.
- 2. Access cell formatting: Highlight the data range, right-click, and select "Format Cells".
- 3. Select custom category: Navigate to the "Custom" category under the Number tab.
- 4. Apply the format: Type 0 0/8 into the format box and click OK to apply the fraction format instantly.

Frequently Asked Questions
Can I format fractions to show sixteenths instead of eighths?
Yes, you can display fractions as sixteenths by selecting the cells, opening the Format Cells dialog, going to Custom, and entering 0 0/16 in the Type box.
Why is my fraction displaying as a date?
If you type a fraction like "1/8" directly into an unformatted cell, the software often interprets it as January 8. To fix this, either apply the custom fraction format before typing the data, or type a zero and a space before the fraction (e.g., "0 1/8").
How do I hide the whole number and only show the fraction part?
If you only want to see the fraction part (e.g., displaying "3/8" instead of "0 3/8"), use the custom format code ?/8 or # ?/8 instead. This prevents the leading zero from appearing on fractions less than 1.
Will applying this custom format change the actual value of my data?
No, custom formatting only alters how the number is visually displayed on the screen. The underlying exact decimal value remains unchanged in the cell and will be used properly for any mathematical calculations.




