Formatting Issues

How to Display Excel Fractions as Eighths (0/8 and 1 0/8)

Amos GikundaAmos Gikunda Nov 4, 2026 870 views

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.

How to Display Excel Fractions as Eighths
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.
Before you start

Ensure the cells you want to format contain actual numerical values, as text entries will not be affected by custom number formatting.

Solution 1Recommended

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.

1
Select the target cells

Highlight the range of cells containing the numbers you want to format as eighths.

2
Open the Format Cells dialog

Right-click on the selected cells and choose "Format Cells" from the context menu, or press the shortcut keys Ctrl + 1.

3
Navigate to Custom formatting

In the Format Cells dialog, go to the "Number" tab and select "Custom" from the Category list on the left side.

4
Enter the fraction format code

In the "Type" input box, enter the exact code: 0 0/8. Click "OK" to apply the formatting.

Apply Custom Number Format for Eighths
Calculation Preserved: Your numbers will now display exactly as requested (e.g., 0 0/8, 1 0/8, 2 3/8) while remaining perfectly valid for mathematical formulas and sums.
Seamless Spreadsheet 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. 1. Open your workbook: Launch WPS Spreadsheet and open the document containing your numerical data.
  2. 2. Access cell formatting: Highlight the data range, right-click, and select "Format Cells".
  3. 3. Select custom category: Navigate to the "Custom" category under the Number tab.
  4. 4. Apply the format: Type 0 0/8 into the format box and click OK to apply the fraction format instantly.
Fully compatible with Microsoft Excel (.xlsx) formats and formulas.Intuitive custom formatting options for fractions, dates, and currencies.Free, lightweight, and fast-loading spreadsheet application.Tabbed interface for managing multiple spreadsheets easily in a single window.
microsoft office alternative - wps office

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.