Superscript

[MGT]

Is it possible to show supersript in a text entry in excel for example the
symbol for H2O or Cubic metres - m3??

TIA

Mick

 

[Bernard Liengme]

Type H20 in cell
With mouse, select the 2
Use Format|Cell and open Font tab
Click in the subscript box

Similar steps work for m3. But for squared and cubed you can also:
A)Type m; hold ALT and type 179 on numeric keypad to get m^3.
B) Type cm; hold ALT type 0178 om numeric keypad to get cm^2

Best wishes

 

[MGT]

Cheers Bernard, - one of the things I 'used to know' but have forgotten
through lack of use...

 

[MGT]

That second method don't work with a laptop with no seperate numeric pad....

 

[Peo Sjoblom]

You need to "turn it on" on the laptop (Fn+Alt+0179)

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Bernard Liengme]

On my Gateway while holding down Fn and Alt, I have to use the dummy
numeric keys - the ones in blue on the regular letter keys.
Odd, one cannot even use an external numeric keypad to get ALT characters.

 

[Dave Peterson]

And if you do it a lot, you may want to get a copy of John Walkenbach's addin.

http://j-walk.com/ss/excel/files/supersub.htm