Superscript in Custom Format

E

Emece

I want to do a custom format that includes Km2, with the 2 as a superscript.
First I write it down in a cell and set the 2 to be a superscript. Eventhough
in the cell I see it correctly, in the formula bar I don't see the 2 as a
superscript. So when I select it and paste it in the custom format, the
number is displayed normally and not in the way I want. Why does this happen?

Thanks in advance

Regards,
Emece.-
 
G

Gord Dibben

Format>Cells>Custom

0" Km" Alt + 0178

Type the 0" Km" then hold Alt key and type 0178 on the NumPad at rightside
of keyboard.


Gord Dibben MS Excel MVP
 
G

Gary''s Student

Consider using the unicode symbol for KM2:

㎢

It is U+33A2 (13218 decimal)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Superscript and Subsript 2
Engineering notation of numbers 1,2X103.. with 3 a superscript???? 4
How do I get superscript and reg in same cell 4
Custom Format 3
how do i superscript part of a cell in MS Excel? 8
Superscripts in a cell 8
Superscript in custom format 2
Text as part of Cell Format 1

Top