Formatting Issues

How to Create a Custom Excel Format with Superscript Text and Numbers

Natalie TaylorNatalie Taylor Nov 2, 2026 871 views

Question details

The user needs to display a specific character as a superscript within an Excel custom number format, such as showing '3' as a superscript in 't/m³'.

How to Create a Custom Excel Format with Superscript Text and Numbers
Product
Excel
Device & OS
not provided
Scenario
Applying specific scientific or measurement units alongside numeric values in a spreadsheet.
Observed behavior
Standard Excel custom number formatting features cannot natively apply rich-text character-level formatting (like superscript) to a single character within the format code.
Before you start

Verify if the data in your cells needs to remain as raw numeric values for formulas, or if converting them into text strings is acceptable for your workflow.

Solution 1Recommended

Insert a Unicode Superscript Directly into a Custom Format

If you want the cell to remain a functional number for mathematical calculations, you can insert the Unicode character directly into the Custom Format field.

By utilizing special Unicode characters like ³ instead of rich-text formatting, Excel can append the unit natively while preserving the underlying value as a number.

1
Select the target cells

Highlight the cell or range of cells containing your numeric values.

2
Open the Format Cells dialog

Right-click the selected cells and choose 'Format Cells', or press Ctrl+1. Navigate to the 'Number' tab and select 'Custom' from the category list.

3
Enter the custom format code

In the 'Type' box, enter your desired format. For example, type 0.0 "t/m³". To type the '³' symbol, hold the Alt key and type 0179 on your numeric keypad, or copy and paste the character directly.

4
Apply the format

Click 'OK'. Your numbers will now display the superscript unit while remaining functional for spreadsheet calculations.

Insert a Unicode Superscript Directly into a Custom Format
Advanced Data Formatting

Easily Manage Custom Formatting with WPS Spreadsheet

WPS Spreadsheet provides a highly compatible and intuitive interface for applying custom number formats, managing scientific units, and structuring your complex data effortlessly.

  1. 1. Open your spreadsheet: Launch WPS Office and open your spreadsheet file.
  2. 2. Access cell formatting: Select the relevant cells and press Ctrl+1 to open the intuitive Format Cells dialog box.
  3. 3. Apply the custom rule: Navigate to the 'Custom' category, input your format rule with Unicode characters like 0.0 "t/m³", and click OK to instantly update your data view.
Full compatibility with Microsoft Excel custom formatting rules and Unicode characters.Intuitive Format Cells interface for rapid data presentation adjustments.Seamless processing of advanced text formulas and dynamic cell references.
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the standard superscript shortcut work in Custom Formatting?

Excel's Custom Format 'Type' field does not support rich-text formatting tags or character-level graphical styling. It only accepts plain text input, meaning traditional keyboard shortcuts for superscript are ignored. To solve this, you must use designated Unicode superscript characters.

How do I type a superscript 2 (squared) symbol on my keyboard?

If you have a numeric keypad, you can type a superscript 2 by holding the Alt key and typing 0178. For a superscript 3 (cubed), use Alt+0179. If you lack a numeric keypad, you can copy the character from the Windows Character Map or a web page.

Will a Unicode superscript custom format carry over to Excel charts?

Yes. If you use a custom number format containing the Unicode superscript symbol, the formatted text (such as t/m³) will successfully carry over to your chart axes and data labels while correctly maintaining the numeric scale of the chart.

Will this custom format display correctly if I save the spreadsheet as a PDF?

Yes, Unicode superscript characters used within custom formats or formulas are standard text glyphs. They will render correctly when printing the document or exporting your spreadsheet to a PDF file.