Custom Data Format to Include Superscript

I don't see any way to do it with custom formatting. It can be created in another cell using a formula and a lookup table to convert the last digit to a superscript (actually it strips off the last character and replaces it with a superscript version of it). But then you still have a column of the non-superscript versions and the formula result is not copy/pastable, it loses the superscript when "paste formula results" is used.

If it is a formula then you might be able to do what I suggested, as part of the formula in the same cell.

If you are typing these numbers in, when you get to that digit, use Command Control Shift + to make it a superscript then type the digit. Just remember that it will make the number a text "number". The numeric functions will ignore it but +-*/ will accept it as a number. In a separate column you can multiple it by 1 to make it an actual number if you need to.

If you are doing this a lot and Command Control Shift + is a bit much to type, you can redefine the keyboard shortcut to something easier in System Preferences->Keyboard Shortcuts->App Shortcuts.

Haven't found a way through Custom Data Format.

I'm curious, what is your use case for this?

SG