Formatting Issues

How to Display Unreduced Fractions in Excel (Without Simplifying)

Camila MilosovichCamila Milosovich Oct 16, 2026 870 views

Question details

The user needs a method to display a fraction exactly as entered (e.g., 30/40) without the spreadsheet automatically reducing it to its simplest form (e.g., 3/4), while still being able to use the fraction's numeric value for calculations.

How to Display Unreduced Fractions in Excel While Keeping Them Usable
Product
Excel
Device & OS
not provided
Scenario
Entering fractional data that must be visually displayed in its unreduced form for non-technical team members, without losing the ability to perform mathematical operations on those values.
Observed behavior
When applying the standard Fraction number format, the spreadsheet automatically reduces fractions to their simplest mathematical form, altering the intended visual representation of the data.
Before you start

Before modifying your spreadsheet, determine whether your priority is having a single input cell for simplicity or maintaining an accurate unreduced visual representation, as achieving both requires using helper cells.

Solution 1Recommended

Use Separate Cells for Numerator and Denominator

The most reliable way to keep fractions unreduced and usable for calculations is to split the data entry into two separate cells.

Because standard spreadsheet software evaluates the underlying value of a fraction as a decimal (e.g., 0.75) and displays its simplest fractional equivalent, there is no native number format that prevents mathematical reduction in a single numeric cell. Using separate cells circumvents this limitation.

1
Create input columns

Set up your spreadsheet by labeling one column 'Numerator' (e.g., Column A) and the adjacent column 'Denominator' (e.g., Column B).

2
Enter the raw values

Type your unreduced numbers into these columns. For example, enter 30 in cell A2 and 40 in cell B2.

3
Calculate the numeric value

In a separate column used for mathematical calculations, enter the formula =A2/B2 to retrieve the correct decimal value for further use.

4
Create a display-only cell

If you need a specific cell to visually represent the unreduced fraction for reports, enter the formula =A2&"/"&B2 in a new column. This concatenates the numbers into a text string that displays exactly as '30/40'.

Use Separate Cells for Numerator and Denominator
Ideal for Collaborative Workbooks: This method ensures that non-technical users only have to enter basic whole numbers without worrying about hidden auto-formatting rules or complex data entry methods.
Effortless Data Management

Manage Complex Fractions Easily in WPS Spreadsheet

WPS Spreadsheet fully supports advanced text functions and cell formatting, allowing you to easily set up templates that handle unreduced fractions for your team without auto-simplification errors.

  1. 1. Set up your columns: Open WPS Spreadsheet and create headers for Numerator (Column A) and Denominator (Column B).
  2. 2. Format your display column: Right-click Column C, select 'Format Cells', choose the 'Text' category, and click OK.
  3. 3. Combine for visual display: Enter the formula =A2&"/"&B2 in Column C to perfectly display the unreduced fraction.
  4. 4. Calculate accurately: Use =A2/B2 in Column D whenever you need the actual numeric decimal value for charts or further equations.
100% compatibility with Microsoft Excel formulas and file formats (.xlsx).Advanced text formatting features to prevent unwanted data reduction.Lightweight and fast, ideal for quick data entry and team collaboration.Free to use with a familiar, intuitive user interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel automatically change 30/40 to 3/4?

Spreadsheet software is programmed to simplify fractions to their lowest common denominator by default. It looks at the underlying decimal value (0.75) and displays the mathematically simplest fractional equivalent.

Can I create a custom number format to stop fractions from reducing?

No. While custom number formats (like ?/? or ??/??) dictate the maximum number of digits displayed, they do not stop the software from mathematically reducing the fraction. You can force a specific denominator using a format like #/40, but this only works if every fraction in that column shares exactly the same denominator.

How do I enter a fraction so it doesn't automatically turn into a date?

If you type a fraction like 1/4 into a general cell, the software may assume it is January 4th. To force it to be recognized as a fraction, type a zero and a space before it (e.g., '0 1/4'). Note that this will still reduce the fraction if mathematically applicable. To keep it exactly as typed without reducing, format the cell as Text before entering the data.