Superscripts in Custom Formats

@J. Woolley - Thanks for the Character Map instructions.

I find the easiest way to get special characters is to use the Windows Emoji Panel:
• <windows_key> + Period (".") this will bring up the emoji panel
• In the menu bar select the second last item called symbols (%,∆,+)
• Scroll across to Maths symbols
• Superscript characters are at the top of the maths symbols

I often need to add m² (or cubed) for area (or volume) units to the way numbers are formatted in my sheets.

If I am working in a new workbook, I enter an m followed by the superscript 2 available via the "Symbols" button in the Excel "Insert" Tab. Before pressing Enter to leave the cell, I copy these two characters, exit the cell (Enter or Esc), select the cell I wish to format, and define a new Custom Format as, for example, ##0.0" m²" by typing the " marks and pasting the m².

If one already has a workbook containing the desired Custom Format open, one can simply copy a cell that has been formatted in the desired fashion from there to the current Workbook. That Custom Format is now available for selection at the bottom of the list of Custom Formats in the current Workbook.
I have a collection of Custom Formats defined in a Sheet of my Personal Workbook, which, being in the xlstart folder, is always opened when Excel is started. All I have to do is find the Format I want (or something closely approximating it), copy the cell from Personal into the current Workbook, and edit the custom format if necessary. (Example: why define " cm²" from scratch when all you need to do is add a c character in front of the m character). This newly created Custom Format is added to the bottom of the list.

This Tip mentions the Windows Character Map accessory but not how to use it. If you don't find it under Windows Accessories in the Start menu, type Character Map in the Windows Search box. As illustrated (see Figure 1 below) it has an Advanced view you can use to Search for character names like "superscript" or "subscript" after specifying the Font. Double-clicking a character (or clicking Select) puts it in the 'Characters to copy' box, which you can Copy to the clipboard. Characters with Alt-keystroke support are identified at bottom-right of the window.
The Tip does not provide an example using the superscript character in a Custom Number format. If you want a cell to display integer values with units of cm², for example, the Custom format is
    0" cm²"
where the superscript is pasted from the clipboard created using Character Map. Notice the superscript character must be within quotation marks in a Custom format.
For more on the Windows Character Map accessory, see https://excelribbon.tips.net/T011474_Typing_Check_Marks_into_Excel.html
For more on Custom Number formats, see
https://exceljet.net/articles/custom-number-formats