Formatting Issues

How to Display Decimal Values as Fractions in Excel

Camila Milosovich Sep 25, 2026 869 views

Question details

The user needs to change the cell formatting to accurately display decimal values as fractions instead of rounded numbers.

Product: Excel
Device & OS: not provided
Scenario: Entering decimal values such as 0.5 or 1.5 into a spreadsheet where they do not display in the desired fraction format.
Observed behavior: Excel displays the decimal inputs as rounded numbers because the cells are using an incompatible number format.

Before you start

Verify that your cell values are strictly numeric and not stored as text, as text values cannot be formatted into fractions.

Solution 1Recommended

Use the Number Format Dropdown Menu

The fastest method to convert decimals into fractions is by applying the standard Fraction format from the Home ribbon.

By default, Excel provides a quick-access Fraction format that rounds the decimal to the nearest simple fraction (like 1/2 or 1/4).

Select the affected cells

Highlight the specific cells, such as those in column B, that contain the decimal values you want to format.

Open the Home tab

Navigate to the Home tab located on the top ribbon of the Excel interface.

Apply Fraction format

In the Number group, click the Number Format dropdown menu (which usually displays 'General') and choose 'Fraction'.

Check Underlying Values: If the values still do not display as fractions correctly, double-check that the cells do not contain hidden spaces and that the underlying values are purely numeric.

Solution 2

Apply Custom Fraction Formatting

Use the Format Cells dialog box to apply specific fraction types, such as fractions up to two or three digits, for more precise data display.

Effortless Data Formatting

Easily Display Fractions in WPS Spreadsheet

WPS Spreadsheet provides a highly intuitive interface for handling all your data formatting needs. You can easily switch between decimals and fractions with maximum precision.

1. Open your workbook: Launch WPS Spreadsheet and open the file containing your decimal data.
2. Highlight target cells: Select the cells or columns you wish to convert to fraction format.
3. Select Fraction format: Navigate to the Home tab, open the Number Format dropdown, and choose 'Fraction'.

Instantly convert decimal inputs into simple or custom fractions.100% compatibility with Microsoft Excel formats (.xlsx, .xls).Free and lightweight alternative for all your spreadsheet tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my fraction automatically change to a date?

When you type a fraction like '1/2' into a cell formatted as General, the software often assumes it is a date (January 2). To prevent this, type a zero and a space before your fraction (e.g., '0 1/2') or format the cell as Fraction before entering the data.

How do I force a fraction to not be reduced?

By default, standard fraction formatting reduces fractions to their lowest terms (e.g., 4/8 becomes 1/2). To keep a specific denominator, right-click the cell, choose Format Cells > Custom, and enter a custom format code like '# ??/8'.

Can I convert text that looks like a fraction into a usable decimal?

If a fraction is stored as text, it cannot be used in mathematical formulas. You can convert it by multiplying the cell by 1 (e.g., using Paste Special > Multiply) or by using the VALUE function to convert the text string back into a numeric value.

Document & File Issues