Office for Mac Issues

How to Add Superscript 2 or 3 to Excel Custom Number Format on Mac

Rana GarciaRana Garcia Nov 3, 2026 871 views

Question details

User needs to create a custom number format in Excel for Mac that includes superscript characters to display units such as m² (square meters) or m³ (cubic meters).

How to Add Superscript 2 or 3 to an Excel Custom Number Format on Mac
Product
Excel for Mac
Device & OS
Mac
Scenario
Creating custom number formats for a range of cells containing sums with a descriptive suffix, without converting them to plain text.
Observed behavior
Superscript formatting applied in a standard spreadsheet cell is stripped when copied and pasted into the Custom Format entry box, making it difficult to format numbers with squared or cubed units.
Before you start

Ensure you have the target cells selected in your spreadsheet and verify that your Mac keyboard can access the Emoji & Symbols viewer.

Solution 1Recommended

Use macOS Character Viewer to Insert Superscript Symbols

Since standard cell formatting doesn't carry over into the Custom Format field, you must insert the exact Unicode superscript character directly using the macOS Character Viewer.

The Custom Format entry box in Excel only accepts plain text and Unicode characters. Formatting a normal '2' as a superscript via the font menu does not change the actual character, which is why copying and pasting it into the format box fails.

To resolve this, you can use the built-in macOS Character Viewer to insert true Unicode superscript characters (² or ³) directly into the format field.

1
Open the Format Cells dialog

Select the cells you want to format and press Cmd + 1 on your keyboard to open the Format Cells dialog. Navigate to the Number tab and select 'Custom' from the category list.

2
Enter the base format

Click inside the 'Type' entry box and enter your base number format along with the unit prefix, such as: 0 "m

3
Open the macOS Character Viewer

While the cursor is still in the Type box, press the keyboard shortcut Ctrl + Cmd + Space, or go to the Mac menu bar and select Edit > Emoji & Symbols.

4
Insert the superscript character

In the Character Viewer, search for 'superscript 2' (or 'superscript 3') or look under the Digits category. Double-click the ² or ³ symbol to insert it into the custom format box. Complete the format by closing the quotation marks, resulting in a format like: 0 "m²"

5
Apply the format

Click OK to apply the new custom number format to your selected cells. The values will now display with the proper superscript units while remaining mathematically valid numbers.

Use macOS Character Viewer to Insert Superscript Symbols
Copy and Paste Workaround: Alternatively, you can search for 'superscript 2' on the web, copy the true Unicode character (²), and paste it directly into the Custom Format entry box using Cmd + V.
Efficient Spreadsheet Formatting

Easily Create Custom Number Formats with WPS Office

WPS Spreadsheet provides a seamless and user-friendly interface for customizing cell formats. You can effortlessly append units like m² or m³ to your numbers using standard Unicode inputs, while maintaining full compatibility with Microsoft Excel formats.

  1. 1. Open your document: Launch WPS Spreadsheet and open your workbook containing the data.
  2. 2. Select target cells: Highlight the range of cells where you want to display the m² or m³ formatting.
  3. 3. Access Format Cells: Right-click the selection and choose 'Format Cells', or press Cmd + 1 on your Mac keyboard.
  4. 4. Define the custom format: Go to the 'Custom' category under the Number tab. In the Type box, enter 0 "m²" by pasting the Unicode ² symbol.
  5. 5. Apply changes: Click 'OK' to instantly apply the custom measurement formatting to your data.
Free, lightweight, and fast spreadsheet editorFully compatible with Microsoft Excel (.xlsx) formats and custom number formattingIntuitive cell formatting dialog with straightforward copy-paste supportCross-platform support for smooth operation on macOS, Windows, and Linux
QA img-9

Frequently Asked Questions

Why doesn't copying a superscript from an Excel cell work in the Custom Format box?

Excel's custom format entry box only accepts plain text and Unicode characters. When you format a regular '2' as superscript using font settings in a cell, the underlying value remains a standard '2'. When you copy and paste it into the format box, the plain text '2' is retained and the superscript visual formatting is stripped.

Is there a direct keyboard shortcut to type superscript 2 on a Mac?

Mac keyboards do not have a default native key combination for superscript 2 (unlike Alt codes on Windows). However, you can quickly bring up the Character Viewer using Ctrl + Cmd + Space, or set up a custom text replacement in macOS System Settings > Keyboard > Text Replacements.

How do I format cells to show cubic meters (m³)?

You can follow the exact same process used for square meters. Open the Format Cells dialog, select Custom, and enter 0 "m³". Use the macOS Character Viewer (Ctrl + Cmd + Space) to search for and insert the superscript 3 character into the entry box.