M
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
symbol for H2O or Cubic metres - m3??
TIA
Mick
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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
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
M
MGT
Cheers Bernard, - one of the things I 'used to know' but have forgotten
through lack of use...
through lack of use...
M
MGT
That second method don't work with a laptop with no seperate numeric pad....
P
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)
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
B
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.
numeric keys - the ones in blue on the regular letter keys.
Odd, one cannot even use an external numeric keypad to get ALT characters.
D
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
http://j-walk.com/ss/excel/files/supersub.htm