How to Add Superscript 2 or 3 to Excel Custom Number Format on Mac
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).

- 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.
Ensure you have the target cells selected in your spreadsheet and verify that your Mac keyboard can access the Emoji & Symbols viewer.
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.
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.
Click inside the 'Type' entry box and enter your base number format along with the unit prefix, such as: 0 "m
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.
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²"
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.

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. Open your document: Launch WPS Spreadsheet and open your workbook containing the data.
- 2. Select target cells: Highlight the range of cells where you want to display the m² or m³ formatting.
- 3. Access Format Cells: Right-click the selection and choose 'Format Cells', or press Cmd + 1 on your Mac keyboard.
- 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. Apply changes: Click 'OK' to instantly apply the custom measurement formatting to your data.

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.




