View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Superscript in Custom Format

FormatCellsCustom

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


On Sat, 14 Nov 2009 12:12:01 -0800, Emece
wrote:

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.-