Office Settings & Configuration

How to Use a Word AutoCorrect Fraction in Excel

Maira Mehtab Sep 28, 2026 869 views

Question details

The user wants to utilize a formatted text fraction (created as an AutoCorrect entry in Word with superscript and subscript) inside Excel without converting it into a calculable numeric value.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to insert a pre-formatted fraction from Word's AutoCorrect dictionary into an Excel spreadsheet to maintain rich text formatting.
Observed behavior: The formatted AutoCorrect entry created in Word is not automatically available in Excel because the two programs maintain separate AutoCorrect replacement lists.

Before you start

Before proceeding, determine whether you need the fraction purely as formatted text (with superscript and subscript) for visual purposes, or if it must function as a numeric decimal value for calculations.

Solution 1Recommended

Format Cells as Fractions (Numeric)

If you are open to using numeric values rather than formatted text, use Excel's built-in Number Format to display fractions.

Excel treats fractions differently than Word. While Word handles them as rich text characters, Excel's default fraction tool stores the result as a calculable decimal value.

Select the target cells

Highlight the cell or range of cells where you want to insert the fractions.

Open Number Format

Navigate to the Home tab on the Excel ribbon and locate the Number group. Click the dropdown menu to see formatting options.

Choose Fraction format

Select 'Fraction' from the dropdown list. For more specific fraction types (like up to two digits or sixteenths), click 'More Number Formats' and select your preferred style.

Enter the fraction

Type your numerator, a forward slash, and the denominator (e.g., 11/16) into the cell and press Enter.

Solution 2

Use a VBA Macro for Formatted Text Fractions

Since Excel lacks a rich-text AutoCorrect feature that transfers from Word, use a VBA macro to force specific text characters into superscript and subscript formatting.

Insert Fractions Easily in WPS Office

Seamlessly Format Fractions with WPS Spreadsheet

WPS Office provides an intuitive and free alternative for handling both numeric and text-based fractions across its powerful suite of spreadsheet, document, and presentation tools.

1. Select your cells: Open WPS Spreadsheet, highlight your target cells, right-click, and select 'Format Cells'.
2. Apply Fraction formatting: Navigate to the 'Number' tab, choose 'Fraction' from the category list, and pick the desired fraction type.
3. Enter your data: Type your fraction directly into the cell. WPS Spreadsheet will automatically format it while retaining its underlying numerical value for calculations.

Fully compatible with Microsoft Excel (.xlsx) formatsEasy-to-use cell formatting options for numeric fractionsLightweight application with reliable macro support for advanced text formattingFree to download and use for all your everyday office tasks

Frequently Asked Questions

Why don't my Word AutoCorrect entries work in Excel?

Word and Excel maintain entirely separate AutoCorrect replacement lists. Furthermore, Excel's AutoCorrect dictionary does not natively support the rich-text formatting (such as superscript and subscript) that Word uses to build custom text fractions.

Can I format a fraction as text instead of a number in Excel?

Yes, but you must format it manually. You can format the cell as Text, type your fraction, highlight only the numerator in the formula bar, right-click to select Format Cells, and check 'Superscript'. Repeat the process using 'Subscript' for the denominator.

How do I stop Excel from converting my typed fraction into a date?

If you type a fraction like '1/2', Excel often auto-converts it to a date like '1-Jan'. To prevent this, either pre-format the cell as a Fraction before typing, or type a zero and a space before your fraction (for example, type '0 1/2').

Office App Problems