How to Create a Custom Excel Format with Superscript Text and Numbers
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³'.

- 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.
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.
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.
Highlight the cell or range of cells containing your numeric values.
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.
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.
Click 'OK'. Your numbers will now display the superscript unit while remaining functional for spreadsheet calculations.

Use a Formula Combining Text and Unicode Characters
The TEXT function can be combined with a Unicode superscript character to dynamically format numbers into a formatted string.
Apply Character-Level Rich Text Formatting Manually
If the cell contents are purely text and not required for calculations, you can manually format an individual character as superscript.
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. Open your spreadsheet: Launch WPS Office and open your spreadsheet file.
- 2. Access cell formatting: Select the relevant cells and press Ctrl+1 to open the intuitive Format Cells dialog box.
- 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.

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.




