How to Display Unreduced Fractions in Excel (Without Simplifying)
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.

- 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 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.
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.
Set up your spreadsheet by labeling one column 'Numerator' (e.g., Column A) and the adjacent column 'Denominator' (e.g., Column B).
Type your unreduced numbers into these columns. For example, enter 30 in cell A2 and 40 in cell B2.
In a separate column used for mathematical calculations, enter the formula =A2/B2 to retrieve the correct decimal value for further use.
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'.

Format as Text and Extract Values for Calculation
Enter the fraction as text so it does not reduce visually, then use text-extraction formulas in a separate cell to perform calculations.
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. Set up your columns: Open WPS Spreadsheet and create headers for Numerator (Column A) and Denominator (Column B).
- 2. Format your display column: Right-click Column C, select 'Format Cells', choose the 'Text' category, and click OK.
- 3. Combine for visual display: Enter the formula =A2&"/"&B2 in Column C to perfectly display the unreduced fraction.
- 4. Calculate accurately: Use =A2/B2 in Column D whenever you need the actual numeric decimal value for charts or further equations.

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.




